SSRS Dynamic Ad-Hoc Reports/Report Builder/Report Models
Posted on 2007-04-09
SQL Server Reporting Services
Report Builder/Report Models/Ad-Hoc Reports
We are using Forms authentication- we have our own security system that we tied into SSRS that we use for our login.
In SQL Server Reporting Services, I need the Report Model to display client specific data based on the user that logged in.
For example, VendorA logs in, opens up Report Model X, and the report model displays VendorA's information.
VendorB logs in, opens up Report Model X, and the report model displays VendorB's information.
VendorC logs in, opens up Report Model X, and the report model displays VendorC's information.
The reason I need this, is because we have upwards of 200 vendors. Each Vendor would like to use our Reporting Solution.
As it stands right now, I have to create a distinct DataSource View and Report Model per Vendor.
This does not scale well at all, maintenance is an absolute nightmare and nearly impossible when users want changes or we make upgrades to our system.
Has anybody had any type of success in this realm? This should be basic functionality/design for any system.