We have multiple users across our branch network who can run different reports but I want to be able to limit their access based on "allowed" locations. For example, I want to limit a reorder report for a user so they can only run for their location and not the full company.
Currently I have had to make multiple versions of the same report that are locked into a fixed location but hoping to improve this.
My thought was to have an optional field created called USERLOC where I can use the user name as the VALUE and put their allowed locations within the VDESC field.
Then I use the CURRENTUSER special field in Crystal to link to the user in the optional field I made.
I just can't figure out how to link the CSOPTFH and CSOPTFD tables into my queries. Some users may be allowed to view multiple or all locations whereas some users are only allowed a single location.
Anyone have any ideas on how to accomplish what I'm trying to do, or is there a method that I have completely missed?