Wednesday, May 29, 2013

Report Model Data Source Report builder

Hi,


I guess there is no way sharing the SMDL with users without deploying it to Report Server (SSRS).


What you can do is Create a snapshot of the schema (or whatever you want to expose to customer) in another server (SQL database), insert some dummy data. Then create a SMDL file on top of the datasource in this server and deploy to SSRS on the same server. Expose the report builder for this server to users and let them create and save the reports.


When you move you just need to change the connection string for datasources and some authentication... That's it.


- Girija


No comments:

Post a Comment