How to get information from web to Jaspersoft Studio?

Hi all.

There are many clients. if one of clients want to see his reports, we have to  make reports using information about him. How can I get his infromation from website to jaspersoft Studio and MySQL query? e.g : His unique Key in Database table.

mingyun's picture
Joined: Jul 2 2015 - 8:02pm
Last seen: 7 years 10 months ago

2 Answers:

Use parameters. If you look at a report with parameter, you'll see that they are just part of an url.

hozawa's picture
176441
Joined: Apr 24 2010 - 4:31pm
Last seen: 3 years 11 months ago

If you are using the multi-tenancy feature then you can access the organisation id in a report query by creating this parameter in your report:

$P{LoggedInUserTenantId}

Similarly if you assign attributes to users you can access these using:

$P{LoggedInUserAttribute_myAttributeName}

where

myAttributeName is the name of the attribute you have defined on the server.

 

 

james.t's picture
279
Joined: Jul 21 2014 - 1:45am
Last seen: 5 years 3 months ago
Feedback