All Is there any way of dynamically loading only specific data in a report based on the user who is accessing the report and their access rights which would be stored in different tables? An example of this is a report of cost of mobile phone bills. Each person's phone bill is allocated to a cost centre, there are likely to be between 2 and 20 bills per cost centre. When a report is run we want to display only those bills that the user is allowed to see and the criteria would be (a) IT allowed to see all (b) the cost centre manager can see their own cost centre and (c) some specific people can see multiple cost centres. The information relating to the 3 different criteria is in 3 different tables. Could anyone suggest a way to do this? Thanks in advance! JuliaJulesB

Hi Julesb, Generally, to handle such problem, we could design a table to store the user credentials and let this table associate with the bill table. Then, in the report dataset, join the 2 tables and filter data by the user id. Reporting Services has a built-in field (=User!UserID) to get the current user ID. thanks, Jerry