supressing details sections using crystal basic

[johnuk1]

I have 3 details rows all displaying same fields

I only want to display details b to if a certain field contains a value

I only want to display details c if a certain field contains a value

can this be done using a formula?

 

[johnuk1]

should have said

I am using Crystal 9

I am thinking I should put a formula somewhere in the details section but where and how to say if fieldx>0 then display?

thanks for any and all assistance

 

[bdreed35]

You can conditionally suppress sections based upon the result of another formula or a database field.

Under the Report menu, choose Section Expert.
Highlight Details B from the list on the left.
Click the X+2 button to the right of the "Suppress(No Drill Down)" property.
In the editor, setup your logic so that the logic evaluates to True or False.
Here is an example of the logic:

{table.field} = "A"

This will suppress the section when the field returns "A".

Save and Close.
repeat the process for Details C.

~Brian

 

[johnuk1]

amazing just as i posted this i got the same idea which of course works. Thanks again Brian. I am starting to realize just how powerful crystal reports can be when you know what you are doing!