Condtionally format rows

[TaTips]

I need to conditionally suppress rows in my Crystal 8.5 report.

Psuedo

If parameter = 'Yes' AND column B = '123'
then suppress row.


Example
=======

col_a, col_b, col_c
AAA BBB CCC
KKK 123 CCC -- Suppress this row
NMB N78 KLK

Parameter = 'Yes'

Desired Outcome
===============
col_a, col_b, col_c
AAA BBB CCC
NMB N78 KLK

Are there implications for summary totals too ?

Thanks,

 

[fredp1]

If you suppress rows, the values are still used in the calcs/summaries.
You'll be better off to filter them out if you do not need them. Also the amount of data been retrieved will be less too.

in your record selection add

if {?parameter} and [table.col_b}='CCC' then false
else true

assumed {?paramater} is boolean
(Note use your own names for the parameter and table/fieldnames)

if its a suppression,

if {?parameter} and [table.col_b}='CCC' then true
else false

Cheers
Fred

 

[DallasAggie]

put an "if" condition in your details section Supress:

ex:

if @param = 'Yes' and dbo.colB like '*123*'

 

[kskid]

I would format the section with the following

From the report design tab, Right click on the Section on the left and click on Format Section. Click on Suppress and then Click on x+2 on the right and enter the following formula

{?parameter} = "Yes" and [table.col_b}='CCC'

Any row not matching the above condition will return a false and be displayed.

Cheers,

-LW