Displaying Crystal username on report...

[bessebo]

I tried posting this to the Business Objects Discussions/Forums website under their support and have received no replies:

We run Crystal Enterprise 9 (using Crystal Reports 9) and I want to display the person running the report (their full name as seen in Manage Users in the Crystal Management Console) on the report when they are scheduling it out of Crystal Enterprise. I have heard that with CR10/XI that there is a special field that I can just place on the report. I don't have that option and I have no experience writing custom CSP pages. I have been told that the fields within Crystal Enteprise are:
iStore.EnterpriseSession.UserInfo.UserName and
iStore.EnterpriseSession.Userinfo.UserDesc
I have no clue on where to start on this. Which CSP page should I be modifying and how do I pass these fields to the report. By the way, the report uses a Transact-SQL stored procedure to gather the data for the report. Can anyone point me in the right direction. Maybe there are some code examples out there?

 

[synapsevampire]

If they are loggin on the SQL Serv er using this name, then you can have the SP return the name.

Otherwise there is a 3rd party DLL offered by Ido Millet (one of the strongest contributors here) which might serve your purposes:

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

I believe it returns the current user name from the local PC though, and I'm not sure if it works with CE.

He's a good guy though, at least send him an email.

-k