ceoss tab row supression

[mart10]

I am using cr 2106

how can I do select criteria on a group that is in a crosstab report my cross tab is in footer and all works well except i want to suoress certain groups (rows)

 

[hilfy]

If you're not using the groups you want to suppress elsewhere in the report, you should use the Select Expert to filter them out of the report's dataset. That way Crystal doesn't have to process extra data that won't be used.

If you need to display the data from those groups elsewhere in the report, then you would right-click on each field in the cross-tab, select "Format Field...", then, in the Suppress formula on the Common tab, enter something like this:

{group field} not in ['Excluded1', 'Excluded2',...]

This will suppress all of the fields in the cross tab for the groups that you don't want to see. If you have the option to suppress empty rows turned on in the cross-tab, it won't show the empty rows where data is suppressed.

-Dell



Senior Manager, Data & Analytics
Protiviti

http://www.protiviti.com