Conditional Suppress

[plsathya23]

Im using Crystal report 9.0 .

In my report im using cross tab. I need to suppress the particular column total based on the colum header name. I have tried the conditional suppress but the entire total column is suppressed.

Please say me to way to suppress it.

[rasinc]

This is a bizarre one.

Right-click the column total field. Then select Format, then the conditional Suppression on the Common tab.

In the formula enter
GridRowColumnValue ("ColumnNameAlias") = "text"

So if you check the Formatting of the Crosstab on the Customize Style tab under the Alias for Formulas when you click on the column, you can use that for the ColumnNameAlias and the the text of the column header in double quotes.

For example, I have a cross tab that has months as the columns and there is a formula for the month column called @Month. Each month is three characters and if I wanted to suppress the total for Jun I would enter

GridRowColumnValue ("@Month") = "Jun"

Hope this helps.

[plsathya23]

Hai Rasnic,
Thanks for your reply. It works.

[rasinc]

Glad it worked for you.