Proper way to filter a SSRS report using a BAQ list as a multi-select criteria

[kylel]

I’ve looked and looked and can’t quite find what I’m looking for when doing a BAQ/RDD/SSRS report.

Say I got a BAQ that just shows a product lookup/ID table and want the user to be able to pick a couple product lines.

Can’t filter on the BAQ side since you can’t do an IN on that BAQ dropdown list.

So what is the best solution?

Thanks,
Kyle

[Randy (Randy Stulce)]

I’ve never done a multi-select so I’d probably try to see what stock reports do in this case, like jobtrav.

[jbooker (Josh Booker)]

You can do IN() filters. Dig into this post and related linked topics for transforming multi-select lists to sql etc

Custom Part Context Menu Open With

PSS- I got the grid.ViewOptions > BAQ Options > WHERE expression to work for IN() clause using this technique with this syntax Part_PartNum IN (?{TransView.PartsSQL}) So now it works for a Context Menu ValueIn and a multi-select searchResult with mutli-paste using SearchChipSelector component: [ContextMenu-SearchChip]