Jump to content

Restricting Data from the DB according to a jasper-server username


eyale

Recommended Posts

 

RE:iReport QA 12/05/2010 07:06  

Hi,

I'm creating my reports using iReport and reading the data from a data-warehouse containing data for all customers.

I need to find a way to show a specific customer only data related to his transactions.

This can only be done by adding a 'WHERE' clause with his username to the report query.

So the question is, how can i get the logged in USERNAME (in jasper server) in the report (using iReport)

as a parameter/function/variable... something that i can put in the WHERE so i can show him only data

related to him.

 

Is this possible?


thanks!

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...