Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Report - If null set the text boxes visible to false

Discussion in 'Information Technology' started by tanhus, Jul 28, 2006.

  1. tanhus

    tanhus
    Expand Collapse
    Guest

    I have a report which displays the hours worked on a project or category. It
    gets the information from a time card table which has the field names
    Category Name Text
    Project Name Text
    Hours Number

    Either Category Name is null or Project Name is null for every record.
    Now i want my report to display all the hours worked on the category/project
    names, so that it looks like this.

    Vacation 5
    Health Management 10

    However im having probelems because my report displays the hours for all the
    records even if there is a null record for the Category Name or Project Name.
    I guess I want to know if there was a way that I can set the hours visible to
    false when project name/category name is null.

    I have tried seprating the time card into 2 but then other problems arise
    when i try to combine the two time cards into one report.

    If anyone can help i would greatly appreciate it.
    Thanks
     
  2. Loading...

    Similar Threads Forum Date
    UK British Sikh Report-2016 Breaking News Mar 24, 2016
    1984 The Story I Did Not Report In ’84 History of Sikhism Jun 28, 2015
    Opinion Top Green Beret Officer Forced to Resign Over Affair With WaPo Reporter Breaking News Jun 26, 2014
    United Sikhs New Report Shows Increasing Hate Attacks on Sikhs Sikh Organisations May 21, 2014
    Legal ACLU reports: Judge orders Sikh man, "Remove that rag, or Go to Jail! Breaking News Sep 27, 2013

  3. Sprinks

    Sprinks
    Expand Collapse
    Guest

    Tanhus,

    I think your difficulty arises from having a Category Name and Project Name
    in the same record. Since both have the same relationship to Hours, they
    really are the same conceptual "thing", a WorkActivity.

    Restructuring the data would avoid this dilemna:

    WorkActivityTypes
    -----------------------
    WorkActivityTypeID AutoNumber (Primary Key)
    WorkActivityType Text (Admin, Projects, etc.)

    WorkActivities
    -----------------------
    WorkActivityID AutoNumber (PK)
    WorkActivityTypeID Integer (Forieng Key to WorkActivities)
    WorkActivity Text ("Vacation", "Health Management")

    EmployeeWorkRecords
    ---------------------------
    EmployeeWorkRecordID AutoNumber (PK)
    WorkActivityID Integer (FK to WorkActivities)
    EmployeeID Integer (FK to Employees)
    Hours Integer

    Alternatively, you could skip the "WorkActivityType", and use a
    non-AutoNumber PK for WorkActivities, and use a range of WorkActivityID
    values for Admin and another for projects, e.g.:

    Admin Categories 1-50
    Projects >100

    Hope that helps.
    Sprinks


    "tanhus" wrote:

    > I have a report which displays the hours worked on a project or category. It
    > gets the information from a time card table which has the field names
    > Category Name Text
    > Project Name Text
    > Hours Number
    >
    > Either Category Name is null or Project Name is null for every record.
    > Now i want my report to display all the hours worked on the category/project
    > names, so that it looks like this.
    >
    > Vacation 5
    > Health Management 10
    >
    > However im having probelems because my report displays the hours for all the
    > records even if there is a null record for the Category Name or Project Name.
    > I guess I want to know if there was a way that I can set the hours visible to
    > false when project name/category name is null.
    >
    > I have tried seprating the time card into 2 but then other problems arise
    > when i try to combine the two time cards into one report.
    >
    > If anyone can help i would greatly appreciate it.
    > Thanks
    >
     

Share This Page