Dynamic report table for a report

[mandm]

 I have a simple requirement that their are several copies of same table and when different users login and run the report the report should run against different tables corresponding to that users permissions, so what i wanted to ask was what would be a good architecture for this kind of report

should i user a report table name as a parameter? can i use it like that?

[ramnik]

You can use LoggedInUserRole or LoggedInuserName - parameter to report query to differentiate the data based on permission by user

Ramnik Kaur

Senior QA Engineer

[mandm]

 No I really don't want to differentiate the data display, but that the report should be able to run for different tables based on user input? i might be not making myself very clear let me try and example

 

i have 2 users user1 and user2 and 2 tables table1 and table2, so when user 1 logs in and runs the report it should run against table1 and when user 2 logs in the report should run around table 2