Jump to content
Changes to the Jaspersoft community edition download ×

Input Control data specific to organization


Recommended Posts

I have a couple of input controls when launched in a JRS report is showing values to users from all organizations.  For example, if I have a database with employees from Honda, Toyota and Jeep (all in one database), but each record in the database is contolled via an organization ID, when an employee from Honda opens a report to choose a car type, they should only see Honda cars from the input control list.  Currently, they see all cars in the database.  Support tells me to create a parameter in the studio report called LoggedInUserTenantId and then an input control: single-select query, select id, tenantid from jitenant where tenantid = $P{LoggedInUserTenantId}.  Unfortunetly, I cannot get this to work.  

Does anyone have any tips to control the values of an input control based on the users organization?

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

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...