Subreport Question

[jschodde]

I have a report which requires multiple reports in one. I know I need subreports but I'm having trouble getting the data to print in the right place.

In the main report I have a summary table with ticket numbers - nothing fancy.

In the subreport I need to show each ticket number with additional details.

In effect, the user wants to scan the summary table at the top, then pick a ticket number and look further down the report to see all the details.

Main Report:
Ticket Number Date
------------- ---------
1 mm/dd/yy
2 mm/dd/yy
3 mm/dd/yy
------------------------
Count: 3

Sub Report #1:
Ticket Number Description (can span more than one page)
------------- ------------------------------------------
1 xxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxxxxxx

2 xxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxxxxxx


Thanks,
Jeff

 

[lbass]

Instead of using subreports, you could create the report with a group on tickets and with the summary information in the group header, and then add the details to the detail section, which you then hide. The groups would then be available for drilldown to the detail level as the user wishes.

As an alternative, you could also potentially use a crosstab in the report header, with the ticket details in the main report. It is unclear whether you want all or only one selected ticket and its detail to show in the report detail section.

-LB