Programming Help

I have report that I am having 2 issues writing and could use some help.

I have a drop down box that list devices and group of devices.

{@Device.A} = {device.device.A}
Works fine

1) If {@device.A} is a group I am not sure how to proceed.

I need CR to look at each device in the group and compare for each device in the database and if it matches give me data.


2)Compare{@device.A} to a device group in the database.

{Group.device} has multiple device and I need {@device.A} to compare to each device in that group.

Please contact me if you need more information or if I am not clear enough.
[email protected]

A better description of what I am trying to do.

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.