Display part of the detail info in Group Footer section

[Former Member]

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

[abhilash_kumar · Accepted solution]

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