Hi, I have a report which uses uer!username for filtering the DS. HOwever I would like management users to be able to view the full report off all users. What would be the best practice for this? I mcurrently added a boolean parameter for user filtered or all users report. The filter depends on this parameter too. Then I made a linked report with the above default hidden parameter of user filtered (so that one report would be available for management and one for specific users). I don't know why but when I run it in VS it runs correctly (according to this parameter) but on the reporter site no matter what value I give the parameter (all/ user specific) in the report parameters properties page it runs as user specific. Any idea why? Namnami

same question http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/fdec7f0d-4178-44b4-8541-990d4e982778 There are 10 type of people. Those who understand binary and those who do not. My Blog | Hire Me