Suppress a Crosstab row conditionally

[mgakhar]

Hi,
I have a Crosstab with about 20 rows and 1 column and 1 summarized field.
In the Customize Style tab, I have Suppress Row Grand Totals and Suppress column grand totals as Yes. For all rows I have Suppress subtotal as Yes also.

What I need to do is to not display some of the rows conditionally. If I right click on a particular row and go to Format Field --> Common and check Suppress and provide the condition, on execution it simply displays an empty column. I dont want to see the empty either.

Any help would be appreciated.

Im using CR10.

Thanks,
MG.

 

[IdoMillet]

What is the condition?

- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[mgakhar]

Well the condition is based on the users input. The user doesnt want to view some information and that I need to suppress.

MG.

 

[lbass]

Instead of suppression, use the condition in your record selection formula, as in:

{table.field} = {?parameter}

Or if the user is choosing fields to exclude, then change the formula to:

{table.field} <> {?parameter}

-LB

 

[mgakhar]

This will just filter records. That is not what I want to do. I want suppress an entire Column condionally.

MG

 

[lbass]

Filtering is generally superior to suppression. You are not providing enough information. Please explain why filtering is not an option--it is actually much simpler than conditional suppression in a crosstab, and it is difficult to actually remove the space once suppression is implemented. Perhaps show some sample data. What exactly is the condition you want to use for suppression?

-LB