Posted on 2013-05-15
I'm learning something new at work. Joy. =) In all seriousness, I like crystal reports... just can't figure a group by issue. I'm hitting two SQL tables. Here's my command code:
FROM ADUsersAndGroups A,
WHERE A.DistinguishedName = B.MEMBEROF
In the crystal reports grouping feature, I am using the follwing:
Group by AccountName (this column has users and groups).
In the detail I would like to list the users to each group,
so I added B.Username (which is like the ID) and the A.DisplayName (description or full name of group/user)
But here's my problem... the display name used on the detail gives me the group name again and not the full name for the user Id. I currently do not have any of the tables linked. Any suggestions would be greatly appreciated.... im in the 23rd hour and it's all starting to run together. I just know I'm close... just cant quite get there from here. Thanks!!