0

How do I set datasource to my rdl reports after deployment?

Currently I have created 2 different data sources for 2 different clients.

And specify that on rdl reports at the time of deployment.

But how can I do this after deployment at runtime when user clicked on show report

Neo
  • 15,491
  • 59
  • 215
  • 405
  • What about an rs.exe script with appropriate parameters? See http://msdn.microsoft.com/en-us/library/ms162839(v=sql.120).aspx . The answers at http://stackoverflow.com/questions/14546125/change-ssrs-data-source-of-report-programmatically-in-server-side/ and http://stackoverflow.com/questions/16083951/ssrs-rdl-mapping-datasources-programmatically/ can give some ideas. – Ian Preston Aug 27 '14 at 12:15
  • 1
    So you want a parameterized data source? – B Woods Aug 27 '14 at 13:20
  • @B Woods yes but i wonder that how can I set datasource dynamically after deployment ? – Neo Aug 28 '14 at 05:10

0 Answers0