Instructions on suppressing records in Crystal Reports
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?
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.