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