Post reply

SSRS Portability similiar to SSIS

  • February 13, 2015 at 12:46 pm

    #1777599

    If I am not mistaken (forgive me, I have not done this in awhile) you can use a shared datasource. Say you have a shared datasource called DS1... You would have DS1 setup in your dev environment configured accordingly and another shared datasource in production configured to work there. Provided that both data sources are configured correctly, the report will work just fine when it is deployed to either environment without any changes to the RDL.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

  • February 13, 2015 at 12:53 pm

    #1777600

    Oops..sorry dude, I forgot to include this in the problem statement: The reports will be deployed onto MS Dynamix. So there is no provision for having a shared DS.

    But your approach sure works on a RS portal.

    Thanks.

  • February 13, 2015 at 1:12 pm

    #1777601

    Bummer, I don't know anything about Dynamics. 🙁

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

  • February 13, 2015 at 2:01 pm

    #1777609

    Me neither lol! I usually modify the xml and change the servers before handing over the rdls to another team. It would be great if SSRS 2008 had a feature like package configurations or project parameters in SSIS 2012

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

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