Anyone else ever had this issue? I'm working on updating the SSRS reports I've made to V11 in our V11 Test system, so I was starting with the latest template, and the ones that I got working are great -- except that the parameter block has nothing to do with the rest of the report. It seems like it's using a random session ID, or possibly pulling the session parameter info from Live or v10 Test while the rest of the report is coming from our V11 test system?
Anyone ever had an issue like this?
Hi Ryan,
I don’t see where the report properties are in Report Manager.
Gloria
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Ryan Creps Sent: Tuesday, November 13, 2012 9:35 PM To: Gloria Ormsby Subject: RE: [Tessitura Technical Forum] SSRS Template's report parameters are random
Keep in mind that there is a setting called OverwriteDatasources on the Visual Studio project. By default this is false which means that changes to the datasource will not be deployed to the report server when the full project is deployed.
The easiest way to check the datasource is to log onto the Report Manager from Internet Explorer and check out the report properties and the datasource properties directly on the Report Server. From there, you can check out which database is being used for each datasource.
+Ryan Creps
+Tessitura Network
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Andrea Crain Sent: Tuesday, November 13, 2012 5:16 PM To: Ryan Creps Subject: RE: [Tessitura Technical Forum] SSRS Template's report parameters are random
Hey, Ryan, how would I check that?
It seems like a plausible idea, but I thought that changing which profile the Configuration Manager points to would change the database for all the reports that got deployed.
From: Ryan Creps <bounce-ryancreps9649@tessituranetwork.com> Sent: 10/30/2012 7:30:23 PM
Seems to me like you have the report pointing to a different datasource than the current DB you are running . In other words, is the report’s datasource pointing to TEST when you are running the report in LIVE?
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Andrea Crain Sent: Tuesday, October 30, 2012 2:38 PM To: Ryan Creps Subject: [Tessitura Technical Forum] SSRS Template's report parameters are random
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!