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!

Suppress Statement

Status
Not open for further replies.

TechUser23

IS-IT--Management
Mar 8, 2007
28
US
In my application, I have two checkbox fields:

Box 1 = Patients W/O IHC
Box 2 = IHC Patients Only

The data is all sitting on the details band. I am using one suppress statement for both of these checkbox fields:

{?INCLUDEWO}= true and {Data.IHC Patient}= 'Yes' or {?INCLUDE}= true and {Data.IHC Patient}= 'No'

The issue Im having is when you view all the patients, I have a 5 page report with all distinct patients (mixed with 'Yes' and 'No'). When I put a checkmark in either field, I get the same 5 page report, however if I had selected Box 1 (Patients W/O IHC), its suppressing their name from the report as I want it to, put its putting a blank space in replacement of it. Its giving me the right return, just not the desired look. Am I missing something obvious here? Any help is appreciated.

 
Go into the section expert->details->check "suppress blank section".

-LB
 
lbass,

You saved my day ... THANKS A MILLION! You answer alot of questions on here ... do you teach crystal reporting perhaps?
 
Only at a local users group--I'd like to do more. Glad that helped.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top