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
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