passing logged in user name dynamically to query

[MohanRao]

Hi,

 

Is there any way I can pass the logged in user name to the report query at run-time?

 

I have tried using $P{UserName} in a text field in the iReport, but when seen in the browser, it show null.

 

I have tried the same thing with $P{LoggedInUser} also. But it fails (gives null).

 

Thanks,

Mohan.

[swood]

You could have one parameter in your report that isForPrompting that allows you to enter the user name.

 

Have an expression in the parameter you use that selects either the isForPrompting parameter or the one being set by JasperIntelligence when it is running.

 

Sherman

JasperSoft