Hi,
I hope someone can help me with this.
I have a table that contains the following fields
"Project Name" (Numerous projects included)
"Group Name" (Contains numerous names)
"Group Type" (There are only two types - "Security Group" or "Distribution Group")
"First Name"
"Last Name"
Every entry in the table has a "project name", then a "group name" then the "group type" then the "first name" and "last name"
I want to create a report that is grouped by "Project" and lists all the members of each "Security Group" only, but alongside their name, it shows the name of the "Distribution Group they belong to (If they belong to one)
What I believe i want is to somehow have the "Group Name" appear twice in the detail of my report, but filter the results depending on the group type
Any help would be appreciated.