Returning Report Users Log-in

[kutz13]

We're using CR8.5 to create reports in an application using an Oracle 8i DB.
At run-time the reports are using the currently logged-in users credentials. Is there a way to return the logged-in username to a Crystal Report along the 'SELECT user FROM dual' function in Oracle?

 

[synapsevampire]

There's UFL's:

http://www.milletsoftware.com/CUT_Light.htm

Or your application could issue a select user... and pass it to the report.

Or you can create a SQL Expression, which is essentially SQL in a formula which is then passed to the database. If you have lots of rows being returned, you'd probably be better served creating a subreport and placing it in the report header or footer so that it's only issued once.

-k

 

[kutz13]

Thanks for the link.

Having never created a SQL Expression field in CR - is it as simple as 'SELECT user FROM dual', or is there specific syntax that I need to follow?