Who is running the report - USERNAME

jackiev · Oct 22, 2009

I would like to inbed some minor security in a report to display different fields based on the name of the user who is running the report.
How do I extract the USERNAME?

example:
if USERNAME is 'staff' then display names & phone numbers
or if USERNAME is 'boss' then display names, phone & dollars.

NollaunoUK · Apr 19, 2010

You should be able to extract the information from the OS and session that your running. Put the resulting query into && variables, then you will be able to manipulate the resulting output.

Regards
Andrew

gizzy17 · May 17, 2010

Depending on how the security has been setup.....and other changes may need to be applied....

You can use either GETUSER which is the ID that is being used on the system if the reporting server security is turned on

-SET &USERID = GETUSER('A8');

or if security is off, this will provide you with whatever was passed for IBIC_user

-SET &USERID = CNCTUSR('A8');

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Who is running the report - USERNAME

jackiev

MIS

NollaunoUK

Programmer

gizzy17

Vendor

Similar threads

Part and Inventory Search

Sponsor