Display user name - ReportNet

[ReportNetGirl]

Does anyone know how to display the name of the current user on a report using ReportNet?

 

[leveyp]

Try inserting a calculation. Depends on the database you are using, for instance Teradata should support 'current_user'. Having said that I've just tried 'user' which is supported by DB2 but RN returned an error. Good look!

 

[leveyp]

DOH !! If you do get the SQL to return current user (need to add Tabular SQL ) then of course all that gets returned is the Account that you defined in the data source connection. Sorry, well it is Friday - time for a beer

 

[Prasad678]

ReportNetGirl,

You wanna see the DB user or ReportNET user?


Prasad
RPrasad1@Chn.Cognizant.com

 

[Prasad678]

Try this :

Create a Calculation of the type 'Detail'.
In the expression editor, type :

#sq($dbCatalog{$account.personalInfo.userName})#

Have this calculation in header or anywhere. Now u shud be able to see the database name.





Prasad
RPrasad1@Chn.Cognizant.com