How to get information from web to Jaspersoft Studio?

Jaspersoft Community 'Read-Only' as of July 8, 2022

Transition to New TIBCO Community Just Weeks Away

You can still search, review wiki content, and review discussions in read-only mode. Please email community@tibco.com with questions or issues requiring TIBCO review or response.

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: 6 years 11 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
132286
Joined: Apr 24 2010 - 4:31pm
Last seen: 3 years 3 weeks 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
233
Joined: Jul 21 2014 - 1:45am
Last seen: 4 years 5 months ago
Feedback