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
Could anyone suggest a way to do this?
Thanks in advance!
View Complete Post