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?
