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

Supress value if other field value is

Status
Not open for further replies.

nortonm

Technical User
Jul 20, 2005
3
GB
Hi

Sorry, relatively low level Crystal User question I think...I have a report which shows assets booked out, so I linked the asset table to the incident table so they can see the status of any asset (ie 'booked out', 'pending' or available). I have told the status field not to display any entry [display ""] if is = 'CLOSED'. This means they (the asset owners) can see easily in a report what is booked or pending, because there are entries, and if it is available all fields are blank. However, I can't figure out how to supress the data display on the other field ie booked date, time, user, user phone no if the STATUS field = 'CLOSED'. I don't want to supress the record, as I would like them to see All assets, whether booked or available. I'm not sure how to do this.

Any help gratefully received
 
Right-click on the field you want to selectively suppress. Choose [Format Field] and then the Common tab. Suppression is 4th line down if you have Crystal 10. (There is also a [Suppress If Duplicate] near the bottom.
Choose the formula icon (x+2 and a pencil) for suppression. Enter a formula; e.g.
pumpstat = Previous(pumpstat) and changeflag <> "Y"

[yinyang] Madawc Williams (East Anglia, UK) [yinyang]
 
Hi

Thanks for that pointer to the selective suppress - that's going to prove very useful. I'm afraid I don't understand the formula you wrote - what does 'pumpstat' refer to? I have to up my knowledge of the syntax etc. What I would like to tell these fields (Book date/time/user/phone No] to do is : if field 'STATUS' is equal to 'CLOSED' then suppress - and I don't know the syntax to initiate that action - I've tried all sorts of combinations that I can think of (admittedly not that much). Does it make a difference what the field data type I'm suppressing is? (eg string/date/number etc - it's a date field)

Many Thanks
 
You can select all fields you want conditionally suppressed->format objects->common->suppress->x+2 and enter:

{table.status} = "closed"

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top