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!
Thank you, Troy.l
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 Troy Nelson Sent: Wednesday, October 16, 2013 10:43 AM To: Shereen Marino Subject: Re: [Tessitura Technical Forum] Deploying Existing SSRS Reports in Test
Looking at your error, the SSRS report can not deploy because of the tablix error. I'm not sure on how much knowledge you have, but each tablix must be connected to a dataset that references either a query or a procedure. Tablix2 is missing a dataset connection. Go to the tablix properties and set it.
--
Regards,
Troy Nelson
From: "Shereen Marino" <bounce-shereenmarino5792@tessituranetwork.com> To: tnelson@smm.org Sent: Wednesday, October 16, 2013 12:13:54 PM Subject: RE: [Tessitura Technical Forum] Deploying Existing SSRS Reports in Test
Additionally, I receive the following error message when I try to preview the report in Visual Studio. I’ve also attached the error message I receive when I attempt to run the report in Tessitura Test.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Levi Sauerbrei Sent: Wednesday, October 16, 2013 9:36 AM To: Shereen Marino Subject: Re: [Tessitura Technical Forum] Deploying Existing SSRS Reports in Test
I'm not completely familiar with the RAMP architecture, but I assume that it's due to the fact that they have completely separate instances running for SSRS in each environment. When I deploy to Live it is hitting a different server than when I deploy to Test. While I do have only one copy of the SSRS RDL files, the deployed reports live on separate machines for Live and Test.
For Infomaker reports there are actually separate copies of the PBL files for live and test since the reports in the PBLs are the actual files being executed against when the reports are run. For SSRS the deployed reports are not the same files as the RDLs in the Project.
From: Chris Jensen <bounce-chrisjensen8841@tessituranetwork.com> Sent: 10/16/2013 9:23:50 AM
Levi Sauerbrei: 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.
Levi Sauerbrei:
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.
Strange. As long as I copy the impresario and ReportServer dbs to Test at the same time, my custom SSRS reports work fine w/o deploying again. Is it a RAMP requirement of some sort? Sorry to misinform if so...
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!
Spam Not spam Forget previous vote