I am have a custom SSRS report that has a list as a parameter. The Performance Seating Book report (also SSRS) has a list parameter and it has a chicklet next to it. Does anyone know how/where to create the chicklet? I am thinking it is in grsetup but I couldn't find it. Thank you in advance!
Debbie
Hello there!
The List button/chiclet appears automatically if the parameter is single-select, datatype of Number, and the table_name field contains either “T_LIST” or “VS_LIST”.
Hope that helps!
-Ryan Creps
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Rachel Schlaff Sent: Monday, November 21, 2016 5:24 PM To: Ryan Creps <rcreps@tessituranetwork.com> Subject: RE: [Tessitura Technical Forum] How to create a List Selector chicklet in a custom SSRS report
Is the multi-select checkbox checked?
From: Debbie Jacob <bounce-debbiejacob1796@tessituranetwork.com> Sent: 11/21/2016 9:45:19 PM
Hi!
I stole all this from the Performance Seating Book report (so I cannot take any credit for it). The drop down list works just as it should. I just can’t figure out the chicklet part.
Data Type: Number
Table Name: vs_list
Display Column: list_Desc
Data Column: list_no
Order by: CASE WHEN created_by = dbo.fs_user() then 0 ELSE 1 END, list_desc
Much Thanks!
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Rachel Schlaff Sent: Monday, November 21, 2016 4:30 PM To: Debbie Jacob <djacob@mos.org> Subject: Re: [Tessitura Technical Forum] How to create a List Selector chicklet in a custom SSRS report
Hi Debbie,
What are you using as the Data Type, Table Name, Display Column and Data Column for the parameter in Report Setup?
From: Debbie Jacob <bounce-debbiejacob1796@tessituranetwork.com> Sent: 11/21/2016 4:06:38 PM
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!
Thank you both!!! Especially for the speedy response! It worked.