suppresed records 1

[straud13]

I have a details section that has a suppression formula in it. If the suppression cancels all rows from showing for a particular group the group header still shows because there are records there, they are just supressed. How can I count the number of displayed (non suppressed) records so I can also suppress the group header if 0 records are displayed for that group.

Crystal 9

 

[lbass]

What is your suppression formula for the detail records?

-LB

 

[straud13]

if len(case_monitor) > 0 then true

if the field is populated then do not show this record

 

[SmpTraining]

There's a useful solution to this sort of problem:

Create a formula to return 1 or 0 depending on whether your condition is met. Summarize this formula by the appropriate group(s). Supress the group header/footer based on this subtotal value.

This formula needs to be:

@field_exist?
if len(case_monitor) > 0 then 0 else 1

Summarize @field_exist? at the group level

Supress the group header/footer if sum of field_exist is zero




Steve Phillips, Crystal Trainer/Consultant

http://www.smptraining.co.uk