Supress value if other field value is

[nortonm]

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

 

[Madawc]

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"

Madawc Williams (East Anglia, UK)

 

[nortonm]

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

 

[lbass]

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

{table.status} = "closed"

-LB

 

[nortonm]

Beautiful!! Thanks very much!!