I have a report that needs to show the differences between two users. The problem I have is that the users can either have there own access rights or inherit them from a 'role' (all stored within the same table) How do I say in crystal speak 'If USER.ROLE is null then display USER.ACCESS otherwise display USER.ACCESS where USER.KEY=ROLE' I'm sure its relatively easy on any day but a Friday...
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Selection conditions
- Thread starter Horns
- Start date
Dear Horns,
If I understand your logic then this may be right. I don't have appropriate data to test, but try:
If not (isnull(USER.ROLE) and USER.KEY = USER.Role) then User.Access
else if
isnull(User.Role) then User.Access
else User.Role
Hope this helps,
ro Rosemary Lieberman
rosemary@microflo.com, Microflo provides expert consulting on MagicTSD and Crystal Reports.
If I understand your logic then this may be right. I don't have appropriate data to test, but try:
If not (isnull(USER.ROLE) and USER.KEY = USER.Role) then User.Access
else if
isnull(User.Role) then User.Access
else User.Role
Hope this helps,
ro Rosemary Lieberman
rosemary@microflo.com, Microflo provides expert consulting on MagicTSD and Crystal Reports.
- Status
Similar threads
- Locked
- Question
- Locked
- Question