Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Instructions on suppressing records in Crystal Reports

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
Former Member replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question