Showing/printing detail section based on data

[Imbriani]

Hi all,

I am using Crystal Reports XI with Windows XP and am fairly new to Crystal Reports, even though I have used it for years as part of MS Access.

I have a report with several detail section. One of the sections, I would like to have print/show based on the presence/absence of data in one field within this detail section. I know that I can suppress or not if data is blank, but is there a simple way to accomplish this with a conditional statement?


Kathy

 

[IdoMillet]

Just use the Suppress expression for that section.

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[lbass]

Instead of suppression you could create a formula like:

if isnull({table.field}) or
trim({table.field}) = "" then
{table.otherfield}

You would probably want to format the section to "suppress blank section".

-LB

 

[Imbriani]

Could I do something like

If isnull({tablefield1}) and isnull({tablefield2}) then
true else
false

I have found that I need to put another field in there to accomodate some reports.

 

[lbass]

If you are setting up a conditional suppression formula, then yes.

-LB

 

[Imbriani]

I have found a way to put a formula into the detail section to supress it under certain conditions:

If {LabNumber.SampleType} = "Mixture" Then
True

but when previewed, the entire report produces no data. Any idea why this is happening?

 

[lbass]

Please explain in more detail what you trying to do.

-LB