• Replies 2 replies
  • Subscribers 339 subscribers
  • Views 60 views
  • Users 0 members are here
Related

New SSRS template

Brian Graham
$organization

I've created a new report in SSRS using the (new) TessituraReportTemplate.rdl as a basis. When I run it in Tess I'm getting this error: "The 'pUserGroup' parameter is missing a value". I did not include the four SSRS parameters in the report set up as I thought that this was not necessary with the new template. In fact, I've got another report using the same template that runs fine (didn't include the ssrs parameters for those either.) Anyone want to take a guess at what I might have missed?

  • $organization

    The new report template does not have a parameter named pUserGroup.  I think you might be trying to use an older version.  The new v11.0.3 version (recommended over any other version) is available in the TessituraSampleLibrary in the 11.0.3 download on TASK, OR alongside the new TCast:

    http://www.tessituranetwork.com/network/Learning/Tessitura%20Hosted%20Training/Leveraging%20SSRS%20in%20Version%2011.aspx

     

    The “p” has been dropped from all of the parameter names in the v11 version.  For WebReports (Tessitura) to pass these values without having them defined in the Report Setup, they should be named UserGroup, UserId, CompanyName, and RequestId.  These names are case-sensitive.

     

    Hope this helps.

     

    +Ryan Creps

    +Tessitura Network

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Brian Graham
    Sent: Thursday, June 28, 2012 6:36 PM
    To: Ryan Creps
    Subject: [Tessitura Technical Forum] New SSRS template

     

    I've created a new report in SSRS using the (new) TessituraReportTemplate.rdl as a basis. When I run it in Tess I'm getting this error: "The 'pUserGroup' parameter is missing a value". I did not include the four SSRS parameters in the report set up as I thought that this was not necessary with the new template. In fact, I've got another report using the same template that runs fine (didn't include the ssrs parameters for those either.) Anyone want to take a guess at what I might have missed?




    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!

  • $organization in reply to Ryan Creps (Past Staff Member)

    Thanks Ryan! This is working now. I'll mention this here in case anyone else is boneheaded like me - I had the new template in the report, but the report was replacing one that already existed with the old template. I must have given the new report the same report_id as the old one though and I think that where my mess started. I deleted the old report in Report Setup and the old rdl in BIDS and now the new report is working fine.

    thanks again,

    Brian