Crystal report confusion. Can you help?

By beggsr ·
I need to know who has access to doors. A person is given a clearance that allows entry into certain doors. Each clearance will have either a list of single door(s) and/or a door group(s). A door group consists of multiple doors. I have 2 issues.

1) I have entered all the doors and doors groups inside a parameter drop down box. If I select a single door name from the parameter, it will only compare to single doors in each clearance and print out a list of all approved person with there clearance. It will not parse any data inside any door group inside the clearance.

2) There are times that I need to know who has approved access to multiple doors. Instead of running multiple reports, I would like to make a ?door group? that includes all doors that I need to run the report on. I would like the report to look at each door inside the ?door group? inside the parameter and compare to all the clearances and print out a report for each door and who has approved access.

thank you for any guidance.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums