Parameter containing Tessitura User Group not passed with token <<p#>>

Darren, I think this was answered through support, but for posterity here’s the answer.

Parameters using an SSRS Type other than Standard (Visible) are only handled when the report is run, and not provided for dependent dropdowns when working in the parameter window.

In v11, these SSRS Type parameters are no longer required when building custom SSRS reports to be rendered through Tessitura.  As long as you name the parameter in the SSRS report according to naming conventions (RequestId, CompanyName, for example), the value will be provided from the WebReports app when the report is rendered.  If you are using these in your reports and have different parameter naming conventions, these hidden parameters will still work as intended.

+Ryan Creps

+Tessitura Network

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Darren O'Loughlin
Sent: Tuesday, November 15, 2011 4:52 PM
To: Ryan Creps
Subject: [Tessitura Technical Forum] Parameter containing Tessitura User Group not passed with token <<p#>>

My problem is occurring in the Tessitura Report Setup Module (v10.0.0.0).  I created a parameter (ID = 2) with SSRS Type set to "Tessitura User Group."  It is output correctly when the report is run.  But I have not been able to get it to pass to the Where Clause of other parameters using this syntax (note: 'ug_id' is a valid column to search against):

ug_id = <<p2>>

When I put <<p2>> as the value for another parameter's Display Value, the value of the parameter with ID = 3 is displayed.

So it seems that the parameter I am trying to reference is essentially invisible to the other parameters.

How can I use the User Group to limit values of other parameters?

Thanks.

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!

Darren, I think this was answered through support, but for posterity here’s the answer.

Parameters using an SSRS Type other than Standard (Visible) are only handled when the report is run, and not provided for dependent dropdowns when working in the parameter window.

In v11, these SSRS Type parameters are no longer required when building custom SSRS reports to be rendered through Tessitura.  As long as you name the parameter in the SSRS report according to naming conventions (RequestId, CompanyName, for example), the value will be provided from the WebReports app when the report is rendered.  If you are using these in your reports and have different parameter naming conventions, these hidden parameters will still work as intended.

+Ryan Creps

+Tessitura Network

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Darren O'Loughlin
Sent: Tuesday, November 15, 2011 4:52 PM
To: Ryan Creps
Subject: [Tessitura Technical Forum] Parameter containing Tessitura User Group not passed with token <<p#>>

My problem is occurring in the Tessitura Report Setup Module (v10.0.0.0).  I created a parameter (ID = 2) with SSRS Type set to "Tessitura User Group."  It is output correctly when the report is run.  But I have not been able to get it to pass to the Where Clause of other parameters using this syntax (note: 'ug_id' is a valid column to search against):

ug_id = <<p2>>

When I put <<p2>> as the value for another parameter's Display Value, the value of the parameter with ID = 3 is displayed.

So it seems that the parameter I am trying to reference is essentially invisible to the other parameters.

How can I use the User Group to limit values of other parameters?

Thanks.

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!