Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need to Group Report on Dates Without Using Table 1

Status
Not open for further replies.

nluoma

Technical User
May 21, 2004
2
US
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.
 
Try my suggestion in thread767-1618015--only link the subs to the main report on the date field.

-LB
 
Thank you! You are brilliant! I knew there had to be a way to do this; and your solution worked perfectly.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top