Report Builder - filtering data

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.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
"Eva M." <Eva M.@.discussions.microsoft.com> wrote in message
news:7C18DD4A-8D07-46CC-A837-CAA2D0D5B156@.microsoft.com...
> 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.
>