Surpressing Text Boxes when No Data

[Lanie]

Good Afternoon,

CR8.5 and Oracle

I'm not sure this can even be done, but thought I should ask anyway.

I have text boxes in the group header which define the data (detail section) which appears under it.

If there is no data, then I don't want the text boxes to appear/print.

Is there a way to make this happen?

Thanks in advance, for your help.




Lanie

 

[synapsevampire]

Sure, right click the text boxes and select Format Text->Common->X2 next to suppress and place the appropriate formula, as in:

isnull({table.field})

-k

 

[Patrick69]

Goto Format text-->Suppress and add this formula (on the button to the right of suppress):

IsNull ({YOURDATABASEFIELDHERE}) = True

 

[synapsevampire]

You don't need the = true

-k

 

[Lanie]

Your are all fabulous! It is always a pleasure learning from you all.

That worked perfectly and now I can surpress my the group if it's blank too!

Thanks you so much again! Have a great day!

Lanie