How do I create a summary sheet of Group values without using a subreport?

[Former Member]

Hello,

I have a report (CR 2011 over MySQL) that churns through a lot of data. It presents information in the Details section and the Group Footer section. I want to include a summary sheet as the first page that only shows the Group Footer data. The only way I've figured out how to accomplish this is by putting the same report as a subreport into the Report Header and then suppressing the details section. I don't like this approach because the same data-intensive report is actually running twice now.

I can't just use the "Hide" feature in the Details Section because when I run the report (from the .NET viewer) none of the details print. To print the details I would have to double-click on each Group Footer which launches a new tab with the details for that particular group only.

I know how to create shared variables so not sure if that can play a part.

Thanks in advance for tips in keeping this to one report with a summary page!

Mark

[JWiseman · Accepted solution]

hi Mark,

you can also Insert a Cross-tab to display the summary values. this is assuming that none of the values you are displaying are whileprintingrecords. otherwise the subreport is the way to accomplish this task.

if you are able to use the cross-tab object for the data you want to display you can later hide all of the lines and margins etc.

-jamie

[Former Member · Accepted solution]

Thanks Jamie...I will give this a try!

Mark

[abhilash_kumar]

Hi Mark,

What kind of summary functions do you use on the Group Footer? As long as they're basic summaries (no print time functions etc), you could just move them to the Group Header. The Group header can then serve as your 'Summary sheet'.

If these are printime functions that you're dealing with, then there isn't another way other than using a Subreport to show the Summary sheet. The Subreport itself does not need to be against the same dataset though.

To speed it up, you could perhaps, create a Stored proc that does all the Summarization and use those columns on the report.

-Abhilash

[Former Member]

Hi Abhilash...thanks for your reply. How do I create a stored procedure? Is there a site I can go to learn about creating stored procedures?

Mark

[abhilash_kumar]

Yes, see if this helps:

http://www.mysqltutorial.org/mysql-stored-procedure-tutorial.aspx

-Abhilash