cancel
Showing results for 
Search instead for 
Did you mean: 

Suppress detail and show group total

Former Member
0 Kudos

Hi all,

In my report I have detail section and GF1 section.

In GF1, I have a total group amount which sum up the value from Detail for each group.

I have a parameter which allow the user to choose to generate the report with detail or summary.

Noticed when I suppress the detail, my GF1 value will all become "0".

Is there anyway I can solve this?

thanks

Accepted Solutions (1)

Accepted Solutions (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi Mavis,

How is the summary generated?

Is it generated using a subreport shared variable?

-Abhilash

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Abhilash,

Thanks for your help.

Is it working now.

abhilash_kumar
Active Contributor
0 Kudos

Hi Mavis,

How is the summary generated?

Is it generated using a subreport shared variable?

-Abhilash

Former Member
0 Kudos

HI Abhilash,

Yes.

abhilash_kumar
Active Contributor

Hi Mavis,

Here's what you need to do:

1. Right-click the Subreport > Change Subreport Links > Move the 'Summary Selection Prompt' to the Pane on the right.

2. Go to the Section Expert > Highlight the section that is unsuppressed > Click the formula button beside 'Suppress' and use this code:

{?Pm-?Summary Selection Prompt} = 'Summary'

3. While you're in the Subreport, Go to the Record Selection Formulas > Record and remove the last condition that points to the Summary Selection Prompt.

4. Go back to the Main Report > Right-click the Subreport > Format Subreport > Subreport tab > Check 'Suppress Blank Subreport'.

5. Go to the Section Expert > Highlight the Section that holds this Subreport > Check 'Suppress Blank Section'.

6. Repeat Steps 1 to 5 for each Subreport on the Details Section.

-Abhilash