Database logged in user

[Ray M]

I am trying to limit a Crystal Reports use to only certain users. I need to be able to acquire the current logged in SQL user so I can conditionally suppress a subreport so that userA and userB can see it but not userC.

 

[kray4660]

If you are using the BI platform. I believe the variable CEUser is available (I have never used it myself), and thus you could conditionally suppress using that variable.

 

[Ray M]

I tried the CEUser but it diddn't work. I may have figured it out though. I added a SQL Expression with "{fn USER()}" (without the quotes) and it seems to have worked when I used it in the Section Expert's Conditional Suppress.