I apologize if this has been answered but I can not seem to find the correct post.
I have a CR 2008 report that counts a bunch of stuff in specific columns within tables. This is used for DQ reporting of the transactional system.
The report has been formatted for a single district. What I need to do is have the report auto roll up for one or more districts and or all districts. Currently because the district is the page header it returns a single row and count for each district.
I am looking for a similar function as projected aggregation that is found when using a universe and webi or deski.
If you want to roll up the numbers by district and then total for the report, you’ll need to do the following:
Add a group for district.
Place your summaries in the group header.
Place your grand total in either the report header or the report footer.
Instead of using the LOV that BO_Chief recommended, I would create one that has the list of districts - to have “All” I would use a union statement to add All to the list. If you have districts that come before “All” alphabetically, you can do something like “*All”. You then set up the parameter to be multi-select. The user will then select one or more districts without having to go through the logic of having another parameter to select one, many, or all.
(BOB member since 2003-02-13)
(BOB member since 2004-06-06)