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
Hi Debbie,
What are you using as the Data Type, Table Name, Display Column and Data Column for the parameter in Report Setup?
Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4
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
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!