Instructions on suppressing records in Crystal Reports

[Former Member]

Hi,

I have a Crystal Report (2008) based off a BEx query. Each record or line generated in the query is displayed on a separate page in the Crystal Report. Each record/page contains values from the BEx query, and some hardcoded numbers and descriptions. I would like to suppress all pages/records based off a key figure that equals 0, whether it be using zero suppression or something similar to a condition in the BEx query. I was able to add the functionality to suppress a single key figure based of the value of 0, but I am looking to suppress the whole page. Since the condition and zero suppression is ignored using MDX, does anyone know how I can use the same functionality in Crystal Reports?

Thank you,

Brock

[Former Member · Accepted solution]

Hi,

Write click the section that you put those records -> section expert -> edit the formula of 'Suppress(No Drill-down)', then you can write the formula like if KF1 = 0 then true. This will hide the section dynamically.

Thx, Hao

[Former Member · Accepted solution]

Hi Hao,

Thank you for the information. Before I was just suppressing the fields, and now that I have suppressed the sections the blank pages are not displaying, issue resolved!

Thanks,

Brock