Print login name on report - currentCE blank? 1

[jenlion]

Hi all, I would like to print the DB login name on the report. I expected that CurrentCEUserName would do this, but it's blank. Using CR10 logged in to SQL2K DB. The currentCEUserID is 0.

What do I need to display the user name?

Thanks

 

[Turkbear]

Hi,
The CurrentCeUserName ( and the ID) are created when the user logs into the CE system to run a published report..

It does not exist when running a .rpt file ( not published)
or when no login is needed to run a published one.

The database login name is not ( as far as I know) available to be shown on the report.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[vidru]

If SQL Expression fields are available to you, you can create one with text of CURRENT_USER to get the database login name for a SQL Server db.

 

[vidru]

Scratch the above. The text should be SYSTEM_USER instead of CURRENT_USER.

 

[jenlion]

Thanks Turkbear, didn't realize I was looking at the wrong field.

Vidru, Awesome! I tried current_user and kept getting dbo but system_user works perfectly. Thanks!!!

Jennifer