Retrieve Active Directory Username Without Enterprise? 1

[dsmbwoy]

I know that there is a special field in Crystal XI called 'Current CE User Name' that will display the users username on the report but is there another way to automatically retrieve this information through a formula? I don't have Crystal Enterprise and would like to automatically display a field on the report with the users Active Directory username. I don't want to have to prompt the user to enter this information through a parameter or anything like that. I basically need a field on the report that works like the 'Current CE User name' function would if I had Enterprise.

 

[lbass]

Check to see if you have a function "user" in field explorer->SQL expression->function->system. It is available for my Oracle database.

-LB

 

[dsmbwoy]

Thanks LBASS!