sql server reporting services: Report Builder - filtering data -- sql server reporting services

Report Builder - filtering data

Eva M.
12/14/2005 4:48:02 PM

sql server reporting services:

We have a web application that supports muliple companies (around 500). All
tables in our SQL Server database have a CompanyId field. We want to use
SSRS Report Builder to let end users create Ad Hoc reports. We need to
build a Model/Data View that allows an end user to veiw data from their
company only. How would we filter the data so that our end users do not see
other companies data in the Model that we design?
We can not allow the end user to create a filter for CompanyID at run time.

Re: Report Builder - filtering data

Michael Carr
12/23/2005 1:27:18 AM

I am trying to do the exact same thing (as I'm sure are many others), so any
assistance from Microsoft on this topic would be greatly appreciated...

Michael Carr

[quoted text, click to view]