SQL Server Performance

Change the data src of a report dynamically

Discussion in 'SQL Server Reporting Services' started by ben_leah, Dec 21, 2005.

  1. ben_leah New Member

    I need to be able to change the data source of a report when I run the execute the report. By passing in a connection string or using a custom extension? Does anybody have any ideas or help?
    Many Thanks,
    Ben
  2. Madhivanan Moderator

    If you use Front End application, you can connect by Datasource property. Crystal Reports has this feature. Try the same in SSRS also

    Madhivanan

    Failing to plan is Planning to fail

Share This Page