I have four tables, that log hours for four different ticket types. I want to create a report that shows time logged for the specified user, for a specified period of time, broken down by day. Here is the report structure I have:
Main Report (enter parameters StartDate, EndDate, UserID)
Group (group on dates, by day)
Group Header: Date
Details (nothing)
Group Footer:
Subreport of all hours in changes
Subreport of all hours in incidents
Subreport of all hours in problems
Subreport of all hours in Work orders
End of Report
My problem is that I cannot find a way to group on all dates between StartDate and EndDate in the Main Report without basing it on one of the tables.
If I base it on one of the tables, if there are no hours recorded for that ticket type for a specific day, it will skip that day.
Is there a way to create an array from the StartDate and EndDate and run the report off of that? Or to create a For statement that can drive the report?
Any help would be appreciated.
Main Report (enter parameters StartDate, EndDate, UserID)
Group (group on dates, by day)
Group Header: Date
Details (nothing)
Group Footer:
Subreport of all hours in changes
Subreport of all hours in incidents
Subreport of all hours in problems
Subreport of all hours in Work orders
End of Report
My problem is that I cannot find a way to group on all dates between StartDate and EndDate in the Main Report without basing it on one of the tables.
If I base it on one of the tables, if there are no hours recorded for that ticket type for a specific day, it will skip that day.
Is there a way to create an array from the StartDate and EndDate and run the report off of that? Or to create a For statement that can drive the report?
Any help would be appreciated.