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

Suppress field based on suppressed field 1

Status
Not open for further replies.

djj55

Programmer
Feb 6, 2006
1,761
US
Hello, I have a detail with several fields where I am suppressing one field if it is duplicated. Now, of the several other fields, I want to suppress two others if the field that has been checked for duplication is suppressed.

I do not program in Crystal every day, and have forgotten how to tell if a field is suppressed.

I know where to put the code but I just cannot remember the code to use.

Thank you for any pointers.
djj
 
You will just need to put the same suppression formula in those fields as you did in the field being suppressed.
 
Thank you for the reply.
I used the "Suppress If Duplicated" check box on the "Common" tab of the format editor. Thus it determines the duplicates and I need to determine if it has been done.

Thanks
djj
 
In format field->suppress, you can use a formula like this:

{table.field} = previous({table.field})

...where {table.field} is the field for which you checked "suppress if duplicated".

-LB
 
Thank you, I will try it tomorrow as I have another (VB.NET) priority at the moment.
Thanks
djj
 
Thank you that worked with a little tweek of adding in the group ID {id} = Previous{id} in my IF.
Thanks
djj
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top