If UserA runs Simple_Report, it will use "ASIA" as Location If UserA runs Simple_Report, it will use "US" as Location. If UserA runs Simple_Report, it will use "EUROPE" as Location. I think you meant If UserA runs Simple_Report, it will use "ASIA" as Location If UserB runs Simple_Report, it will use "US" as Location. If UserC runs Simple_Report, it will use "EUROPE" as Location. I'm sure there's lots of ways of doing this. One way is that report has a parameter called LOCATION, $P{LOCATION} and that the default value of LOCATION is an empty string "". Then before the report is run, you use your RBAC (Role Based Access Control) to determine the value of LOCATION. Then you fill that value and pass it into the report. One way I can see. Lots of other ways too I'm sure.