on 06-15-2011 9:07 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.