Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2010
    Posts
    1

    Unanswered: Complicated Report

    I have a Crystal Report to write that will look something like the following if possible. It utilizes about 8 tables. The subreports would pull data from a table on visits. The report is syphoned by stard and end dates.

    Details Section -----------------------------------------

    PatientID PatientName Code Start Date End Date Location Manager TotalVisitDay

    SubReports-------------------------------------------------
    # of Worker Visits
    WkType1: (an aggregate count of visits)
    WkType2: (an aggregate count of visits)
    WkType3: (an aggregate count of visits)
    WkType4: (an aggregate count of visits)
    WkType5: (an aggregate count of visits)
    WkTypeOthers (an aggregate count of visits)
    Total Worker Visits :

    # of Worker Hours Direct Time
    WkType1: (an aggregate count of hours)
    WkType2: (an aggregate count of hours)
    WkType3: (an aggregate count of hours)
    WkType4: (an aggregate count of hours)
    WkType5: (an aggregate count of hours)
    WkTypeOthers (an aggregate count of hours)
    Total Worker hours:

    # of Worker Hours Indirect Time
    WkType1: (an aggregate count of hours)
    WkType2: (an aggregate count of hours)
    WkType3: (an aggregate count of hours)
    WkType4: (an aggregate count of hours)
    WkType5: (an aggregate count of hours)
    WkTypeOthers (an aggregate count of hours)
    Total Worker hours:

    # of Worker Hours Travel Time
    WkType1: (an aggregate count of hours)
    WkType2: (an aggregate count of hours)
    WkType3: (an aggregate count of hours)
    WkType4: (an aggregate count of hours)
    WkType5: (an aggregate count of hours)
    WkTypeOthers (an aggregate count of hours)
    Total Worker hours:

    End SubReports -----------------------------------------
    End Details----------------------------------------------


    Is this report doable? What would I need to know going into it to create this report?

  2. #2
    Join Date
    Mar 2010
    Posts
    4
    I believe it would be doable (without knowing the data or data structure). It appears you have some sort of identifier for the type of worker hours. If you can group by that identifier, then you can create a sub report that will be put in that group footer and pass the dates and identifier to the sub report. As far as the the WkTypes, again that appears to be an identifier that you might be able to group by in the subreport.

    I hope this helps.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •