Automatically add username

[kwirky]

Hi,
Is there any way to create a field etc to allow the name of the user who printed the document to show?

For instance
Report Printed by: {@username}

We create the reports through CR 2008 and they are run by end users on terminals (they log into the terminals using AD) through an MIS. We need the name to come up automatically, not to be a parameter or anything like that.

Thanks in advance.

 

[RTag]

You can use UFL library. This one exposes LoginName:

http://www.viksoe.dk/code/u2lwin32.htm.

It is free. You can also write your own UFL library. Check this link how to do it:

http://www.slxdeveloper.com/page.aspx?action=viewarticle&articleid=103

Of course you can use viewer that can detect and pass the username as parameter. UFL will be easier and cheaper to implement, but if you already use report viewer check if it supports this functionality.

http://www.R-Tag.com

Viewer, scheduler and manager for Crystal reports.
Send your report everywhere.

 

[briangriffin]

Depending on your backend database, you might be able to use a SQL Expression. For SQL Server it would just be:

suser_name()

Oracle is osuser and other db's have similar functions.

 

[kwirky]

Thank you.

I tried the SQL expression and it worked beautifully