Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Sep 08, 2014 at 04:34 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 08, 2014 at 04:36 PM

    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

    Add comment
    10|10000 characters needed characters exceeded