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?

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.