tl;dr: is it possible to have grouping levels within a subreport which gets its data entirely from the main report? I need to produce a single report which takes a single set of data and displays four or more different summarizations/calculations on the data.
=================================================================================
It would be easy enough to make a separate stored procedure call in each subreport. But since a lot of the data will be common to all of the subreports, I'd like to avoid the performance cost of getting the same data from SQL Server repeatedly.
I'd like to get all the raw data once, from a single stored procedure, and link that data to the various subreports within the single .RPT file. So far it seems that I cannot use the Group Expert in a subreport that does not call a stored procedure -- there are no Report Fields displayed to select for grouping.
The subreports could be described as cost summaries, calculated as follows: A summary for all months, A breakdown of just the current month, calculated averages per person/month, and multiple cost breakdowns by plan for the current month.
For the first subreport, I can get the desired data as parameters, by linking desired fields and parameters from the main report. I would need to group this to group this data by the month of a particular date column, with one row per month and a grand total at the end. But if I click on the Group Expert in that subreport, there are no Report Fields available for me to group by.
Since all of the calculations involve a single set of data, I'd like to just get that set from a single stored proc call, and have Crystal perform the various calculations.
Can this be done in Crystal Reports XI, with or without subreports, without having multiple calls to the database that return the same data more than once?
