• Replies 7 replies
  • Subscribers 337 subscribers
  • Views 47 views
  • Users 0 members are here
Related

SSRS Template's report parameters are random

Andrea Crain
$organization

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?

Parents
  • $organization

    It’s actually in the Manage page, accessible from the dropdown menu for a report.  You need to be using Internet Explorer to access the dropdown menu by clicking the arrow to the right of a report.  From there, one of the pages is Data Sources.

     

    +Ryan Creps

    +Tessitura Network

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Gloria Ormsby
    Sent: Wednesday, November 14, 2012 4:29 PM
    To: Ryan Creps
    Subject: RE: [Tessitura Technical Forum] SSRS Template's report parameters are random

     

    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?

     

    +Ryan Creps

    +Tessitura Network

     

    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

     

    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?




    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!




    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!




    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!




    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

    It’s actually in the Manage page, accessible from the dropdown menu for a report.  You need to be using Internet Explorer to access the dropdown menu by clicking the arrow to the right of a report.  From there, one of the pages is Data Sources.

     

    +Ryan Creps

    +Tessitura Network

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Gloria Ormsby
    Sent: Wednesday, November 14, 2012 4:29 PM
    To: Ryan Creps
    Subject: RE: [Tessitura Technical Forum] SSRS Template's report parameters are random

     

    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?

     

    +Ryan Creps

    +Tessitura Network

     

    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

     

    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?




    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!




    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!




    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!




    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