See if this helps you
Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/
MS SQL optimization: MS SQL Development and Optimization
MS SQL Blog: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
Thank you for your question.
I am trying to involve someone more familiar with this topic for a further look at this issue. Sometime delay might be expected from the job transferring. Your patience is greatly appreciated.
Thank you for your understanding and support.
If you have any feedback on our support, please click here.
TechNet Community Support
If above link not help you, can you explain more in detail for what you want to achieve
Microsoft Online Community Support
Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
Not a problem let me tell you what we do with our integration with Crystal Enterprise (CE) and what we are trying to accomplish with SSRS. We create Sql Reports with SSRS the same as we do with Crystal Reports. We currently have ~600 reports we use to support our Global business partners. We have 3 environments in each country we support.
We created a routine to publish reports to CE and retrieve an object reference (object_id), basically a number for each report and store as meta data in a system table. Our Web interface allows a user to schedule reports, we pull the report object_id (parent object) and call a method to run a report instance. The scheduling method allows us to pass the database instance name. We implement Federated Oracle databases, meaning we can run the reports against many Oracle instances in an environment.
Database A, Database B, Database C, Report 123
We can schedule to run Report 123 against Db – A, B, or C by passing the db instance name and using the parent object_id to generate an instance of the report.
From the SSRS implementation to support one country will require creating 600 reports x 3 environments = 1800 rdlc files; now multiple that by the number of countries we support and it becomes ridiculous. We cannot modify the report data source located on SSRS server because two different users could schedule to run the same report using Db A and Db B at the same time.