I'm using Crystal Developer 9.2. I have to write a security report and I have this problem to solve. One security record contains 90+ privilege settings/fields. My security group only wants to see a list of privileges that have been granted, rather than a list of all privileges with a yes or no next to each.
So, instead of seeing:
Access Ticketing System Yes
Update Ticketing System No
Access TimeCard System Yes
Update TimeCard System Yes
Access CoffeePot No
Access Refrigerator Yes
Access Restroom No
They just want to see:
Access Ticketing System Yes
Access TimeCard System Yes
Update TimeCard System Yes
Access Refrigerator Yes
Since all of the security fields are in one record, it seems like they should all be in the Detail section. I can see how to suppress the 'No' privileges so that nothing prints at all, but I can't figure out how to make the other fields 'slide up' so that there are no gaps in the list. I'm guessing that it could be done with a lengthy formula, but if there's an easier way I'd like to know it. If there isn't, I'd like to know if I can do that with a formula.
Thanks!