Post reply

Dynamic Report Connection using Shared datasource

  • December 19, 2007 at 8:22 am

    #119300

    I have approx 50 + reports where in I need to connect to the database dynamically based upon specific time frame.

    I do not want to change the RDL's .

    In the BIS 2005 when i run the report and create a dynamic data source. The connection works. But When i deploy the report and create the dynamic data source with the string it doesnt work.

    The code for the same is below:

    ="Data Source="+ iif(TimeString() < "15:00:00","datasourceName1","datasourceName2") + ";Initial Catalog=catalogname;"

  • December 26, 2007 at 9:01 am

    #762696

    Dynamic Connection Strings are not possible with Shared Connections. These need to be set at the report level

    My blog: jetlounge.net

  • December 26, 2007 at 9:12 am

    #762699

    any alternate way to make chnages

    prob using some .net scripts at report manager level.

    i do not want to touch the reports

  • December 26, 2007 at 9:22 am

    #762701

    Not possible with Report Manager. You would have to build your own rendering front end to control that...but it would still be easier to touch 50 reports.

    My blog: jetlounge.net

  • December 26, 2007 at 9:51 am

    #762718

    Can you please explain how this could be done.

    Thanks

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy