cancel
Showing results for 
Search instead for 
Did you mean: 

Display part of the detail info in Group Footer section

Former Member
0 Kudos

Hello,
I want to suppress some sepecific part of the rows in the Details Section and then the suppress rows show up in the Group Footer Sections in Crystal Report.

Currently the Detail Section is look like this...
Item
1
30
40
AA
9
12
BB
CC

I want to have the Detail Section becomes like this...
Item
1
30
40
9
12

Then AA, BB, CC to be shown in the Group Footer sections...
AA -- Group Footer1
BB -- Group Footer2
CC -- Group Footer3

Thanks,
Jean

Accepted Solutions (1)

Accepted Solutions (1)

abhilash_kumar
Active Contributor

Hi Jean,

1. Create a formula (@Group) with this code:

if isnumeric({item}) then

'*A*' else {Item}

2. Insert a group on this formula field

3. Suppress the Group Header.

4. Copy the Item field from the Details to Group Footer - so you now have the same field on Details as well as Group Footer.

5. Go to the Section Expert > Highlight the Details Section > Click the formula button beside 'Suppress' and use this code:

{@Group} <> '*A*'

6. While in the Section Expert, highlight the Group Footer > Click the formula button beside 'Suppress' and use this code:

{@Group} = '*A*'

-Abhilash

Answers (4)

Answers (4)

abhilash_kumar
Active Contributor

Hi Jean,

Here's what you need to do:

1. Insert a Group Footer 1b section.

2. Go to the Section Expert > Highlight the Group Footer 1b Section > Click the formula button beside 'Suppress' and use this code:

{@Group} <> '*A*'

3. Go to Insert Summary > Choose Qty as the field to summarize > Choose Sum as the operation > Under 'Summary Location', choose 'Group Footer 1'.

4. Move the summary field to Group Footer 1b.

5. Create a formula with this code and place this on the Group Footer 1a:

shared numbervar g2;
if {@Group} <> '*A*' then
g2 := g2 + {Qty}

6. Right-click the formula field > Format field > common tab > Check 'Suppress'.

7. Create another formula to display the total and place this on the Report Footer:

shared numbervar g2;

-Abhilash

Former Member
0 Kudos

Abhilash,

Thank you so much for your time. It works great.
-Jean

0 Kudos

Hi Jean,

Try to keep one question/issue per post so it's easy to search on and find the answer to....

Don

Former Member
0 Kudos

Hi Don,
OK. That Make sense.

Thanks.

Former Member
0 Kudos

Hi

Abhilash,

Thanks for your help. Now my report works perfectly. I have another column in the same report name "Quantity" and need to sum them for the detail section and the group footer section.

The current report output:

The desire report output:

It would be great if you can help me.

Jean