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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

suppress based on another field?

Status
Not open for further replies.

mgason

Technical User
Feb 6, 2003
158
AU
I have a database field that is set to "suppress if duplicated" in the format field dialog.
Can I have TEXT fields in the same section suppress if that database field is duplicated?
How would I do that?
thanks
Mark
 
Right click the field in question and select "format field". To the right of the suppress check box there is an X-2 button for conditional suppression. Click it and enter a formula:

Not OnFirstRecord;
if {Field} = Previous({Field}) then True else False

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top