single select-query input parameter for jasper report

[mandm]

 i have a tricky question, which  i will be glad if addressed by the forum, my worry is that i have a input parameter which i need to have the values changed dynamically, e.g unit_name which can change based on each table so i have a mapping table which i use via the $P{LoggedInUser}.getUsername() parameter in the report, to run a report for a specific user....

But can i use this $P{LoggedInUser}.getUsername() in the single select query option on the server?

my query is 

 

select distinct key from table1 where lst_id in (

select lst_id from table2 where Name = 'units' and file_id in (select fileid from usermap where userid = $P{LoggedInUser}.getUsername())

)

union 

select '%' as key_value

order by key_value asc

 

in this query  i need to derive the distinct keys based on each logged in users table...

 

Can this be done in jasper?

 

 

[andre187]

With Jasperserver Pro you can use all $P, $P! and $X Parameters.

What are you using? Did you try out, ob your solution works?

[mandm]

 yes i used this file to install the jasper server 

jasperreports-server-cp-4.0.0-linux-installer.bin

So i am guessing i have the Community edition, but i have user $P, $P! etc...successfully in my reports, its just that i do not know how to use it on the query based input parameters