• Replies 16 replies
  • Subscribers 339 subscribers
  • Views 191 views
  • Users 0 members are here
Related

Deploying Existing SSRS Reports in Test

Shereen Marino
$organization

Hello,

I'm new to SSRS and I need to deploy reports that exist in Live to our Test environment as soon as possible. Unfortunately, my predecessors did not add any of the custom reports to Test.  There's nothing like trial by fire.  We're on RAMP.  The only instructions I've received from Tessitura are: 

1)  Go into the BIDS project containing your custom reports in LIVE
2)  Change the config to the TEST location and deploy

If someone could step me through this, I'd greatly appreciate it.

Thank you!

Parents
  • $organization

    Thank you, Beth.  This is great information and I’ll give the browser a shot!

     

    Shereen Marino
    Data Analysis Manager | The Phoenix Symphony | Tel. 602-452-0414 | Fax. (602) 253-1772
    SMarino@PHOENIXSYMPHONY.ORG | www.phoenixsymphony.org

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Beth Gilliland
    Sent: Wednesday, October 16, 2013 11:25 AM
    To: Shereen Marino
    Subject: Re: [Tessitura Technical Forum] Deploying Existing SSRS Reports in Test

     

    Shereen -

    In case your issue is not resolved at the field or tablix level...

    While we are not on RAMP, we do have separate instances of SSRS running for Live and Test, so if what Levi says is true, our setup might be still comparable. You might be able to deduce what you have and what you don't have from a browser using Microsoft IE Report Manager interface - that has really helped me clarify what I have in Live and Test, and help troubleshoot things like this. Try going to http://<servername>/Reports - try both your test and live servernames in there, and compare the two setups. (You do need a server login, though, to access this, and maybe that is something that RAMP folks don't have...?)

    I wonder if you might not have a Data Source deployed to your test environment, since you also didn't have any reports deployed there. If your report/tablix is pointing to a dataset that does not live within a data source in the test environment... maybe...?!? I had something similar once when I made a new view or sproc or something that hadn't been pushed out as an SSRS data source the first time...

    Beth

    From: Shereen Marino <bounce-shereenmarino5792@tessituranetwork.com>
    Sent: 10/15/2013 4:24:20 PM

    Hello,

    I'm new to SSRS and I need to deploy reports that exist in Live to our Test environment as soon as possible. Unfortunately, my predecessors did not add any of the custom reports to Test.  There's nothing like trial by fire.  We're on RAMP.  The only instructions I've received from Tessitura are: 

    1)  Go into the BIDS project containing your custom reports in LIVE
    2)  Change the config to the TEST location and deploy

    If someone could step me through this, I'd greatly appreciate it.

    Thank you!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Reply
  • $organization

    Thank you, Beth.  This is great information and I’ll give the browser a shot!

     

    Shereen Marino
    Data Analysis Manager | The Phoenix Symphony | Tel. 602-452-0414 | Fax. (602) 253-1772
    SMarino@PHOENIXSYMPHONY.ORG | www.phoenixsymphony.org

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Beth Gilliland
    Sent: Wednesday, October 16, 2013 11:25 AM
    To: Shereen Marino
    Subject: Re: [Tessitura Technical Forum] Deploying Existing SSRS Reports in Test

     

    Shereen -

    In case your issue is not resolved at the field or tablix level...

    While we are not on RAMP, we do have separate instances of SSRS running for Live and Test, so if what Levi says is true, our setup might be still comparable. You might be able to deduce what you have and what you don't have from a browser using Microsoft IE Report Manager interface - that has really helped me clarify what I have in Live and Test, and help troubleshoot things like this. Try going to http://<servername>/Reports - try both your test and live servernames in there, and compare the two setups. (You do need a server login, though, to access this, and maybe that is something that RAMP folks don't have...?)

    I wonder if you might not have a Data Source deployed to your test environment, since you also didn't have any reports deployed there. If your report/tablix is pointing to a dataset that does not live within a data source in the test environment... maybe...?!? I had something similar once when I made a new view or sproc or something that hadn't been pushed out as an SSRS data source the first time...

    Beth

    From: Shereen Marino <bounce-shereenmarino5792@tessituranetwork.com>
    Sent: 10/15/2013 4:24:20 PM

    Hello,

    I'm new to SSRS and I need to deploy reports that exist in Live to our Test environment as soon as possible. Unfortunately, my predecessors did not add any of the custom reports to Test.  There's nothing like trial by fire.  We're on RAMP.  The only instructions I've received from Tessitura are: 

    1)  Go into the BIDS project containing your custom reports in LIVE
    2)  Change the config to the TEST location and deploy

    If someone could step me through this, I'd greatly appreciate it.

    Thank you!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Children
No Data