Who is running the report - USERNAME
Who is running the report - USERNAME
(OP)
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.
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.
RE: Who is running the report - USERNAME
Regards
Andrew
RE: Who is running the report - USERNAME
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');