suppressing group footer records

[Former Member]

Dear All,

              I want to restrict (not display ) some summation records . my field name is refdetail.debit i want to show xxxx in place of this sum field ,based on some condition(like if segment = ''0000654654') then do not display this group footer sum.

How can i achieve this. Any ideas please.

Thanks & Regards,

akram

.

[abhilash_kumar · Accepted solution]

Hi Akram,

Is 'Segment' the field that you've grouped on? Or is it a field on the details section that shows different segments on each row?

If it's a group field and all rows have the same segment, here's what you need to do:

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

If {segment} = '0000654654' then

'XXXX'

else totext(Sum({refdetail.debit}, {Group_field}),0,"");

Do the same for other fields and use these formula fields on the footer.

You can also do this using the 'Display String' option however, it doesn't work when exported to Excel.

-Abhilash