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.
2 Answers:
Posted on July 3, 2015 at 12:48am
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.