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!
Hello Levi,
Thank you for your assistance. This part is working; however, when I try to deploy the report I receive the following error message. I’ve found the report definition but nothing stands out as an error in the code.
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 Levi Sauerbrei Sent: Wednesday, October 16, 2013 7:12 AM To: Shereen Marino Subject: Re: [Tessitura Technical Forum] Deploying Existing SSRS Reports in Test
Shereen,
I'm assuming that RAMP did the initial setup of your BIDS environment (as they did for us).
In the Visual Studio Editor, there should be a dropdown menu in the top toolbar (just next to the green Arrow icon). This drop down has your different environments in it.
Choose which environment you want and then right click your report in the solution explorer and choose Deploy. You should see some status messages scrolling by. Pay attention to the server names there to make sure you are deploying the report to the environment you want.
The Live to Test copy does bring over your report setup and SQL scripts, but you will need to deploy custom SSRS reports to the Test environment at least once to have them work.
Let me know if you have any questions!
- Levi
From: Shereen Marino <bounce-shereenmarino5792@tessituranetwork.com> Sent: 10/15/2013 5:51:02 PM
I was just informed that Tessitura doesn't refresh the ReportServer and ReportServerTempDB databases on RAMP as part of a Live to Test copy.
If there's anyone on RAMP who's dealt with deploying custom reports in Test, I'd love to hear from you. The only additional information I've received from Tessitura is 'to deploy them in Test with the proper connection info' but since we're on RAMP, I'm not sure what the proper connection info is.
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!
That usually is an issue with parameters or you changed a column name and need to do a refresh. Double check that all parameters are there and refresh your fields.