Hi,
We use crystal reports in one of our departments based on stored procedures and command SQL. These reports use native driver connection or ODBC to oracle database. We use a generic username(eg: cruser) with access to all reporting objects in the database.
Once the reports are published in infoview, we would like to capture the user who is running the reports in real time. So we are looking for a way to capture the crystal user name. In the past we achieved this by using custom parameters(set environment variable) in a universe. But in this development Universe is NOT an option. So we have to use only stored procedure. We thought of SET CONTEXT variable but not sure of how to implement this in crystal connection.
Is there an optimal to way to capture CurrentCEUserName in a crystal connection or a stored procedure
Thanks
Kanth
kanth (BOB member since 2005-09-05)