Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Surpressing Text Boxes when No Data

Status
Not open for further replies.

Lanie

Programmer
Jan 20, 2000
83
US
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
 
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
 
Goto Format text-->Suppress and add this formula (on the button to the right of suppress):

IsNull ({YOURDATABASEFIELDHERE}) = True
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top