Cascade select filtering user controls

[jasemilly]

Hi

I have several rep's using the same report and I filter the results using loggedInUser.

Each rep can filter the report by a user control that currently displays every single customer, regardless of which rep is responsible.

 

Is it possible to filter on the username within the Jasper front end.

 

or

 

have a text box were the type their ID and then filter the dropdown box as a type of cascade??

thanks in advance jasemilly.

[jens_noering]

You can use the Parameter $P!{LoggedInUsername} in select-input Controls.

That will give you the logged in Username that you can use it to filter your sql-query.

 

hth,

 

[jasemilly]

so something like where rep_id = $P!{LoggedInUsername} will work??

 

thanks!!!

[jens_noering]

yes if your username is like the rep_id.
for me its working fine.

if its not working post your query.

 

if this is not possibel you could build a parameter as a textbox where the user can type his id in an filter with this parameter the a second parameter with a single select query.

but you have the security problem when every user can type an id in a box.

better way is a table with set set of jasperserver username an the id and then use a join and a direct filter with the jaspeserver username on the select box. no one has to type an id and there is no security problem.

hth

Post Edited by jens_noering at 12/16/2011 16:00

Post Edited by jens_noering at 12/16/2011 16:05