vinniedialogedu.com Posted February 2, 2019 Share Posted February 2, 2019 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now