BAQ report filter list

[NSP (Dan Carney)]

I have a SSRS report that I am converting to a BAQ report. The SSRS report has a field in the header that list the values that were entered into the bin number parameter using =JOIN(Parameters!Bin.Value, ", ").
The new BAQ report uses a filter so users can enter the bins. I would like to shows the list of bins in the header in the same way as the SSRS report. Example:

Is there a way to do this from the filter?

[aarong (Aaron Gulley)]

You’ve got two ways of doing this. Combining your data using SSRS syntax e.g the =JOIN(YourColumn.Value, ", ") function or using FOR_XML_PATH within the BAQ. The thread can be found here.

Then on your SSRS you can display the column and it will be displayed `Bin 1, Bin 2 etc"

SQL help! Comma separated operations list by assembly using FOR XML PATH - ERP 10 - Epicor User Help Forum (epiusers.help)

[Mark_Wonsil]

Use STRING_AGG instead of FOR_XML_PATH if your using SQL 2017 or higher. You’ll find other users on the list having issues with FOR_XML_PATH on their upgrades.

BAQ Concatenated Rows to Single Field

I wouldn’t use the For XML Path function. Instead, use String_Agg(table.field, ',') The second argument is your delimiter, in this case a comma. It works just like a regular aggregate function, like Sum() or Max() etc. This is assuming that you are on the newish version of SQL

[NSP (Dan Carney)]

Thanks, I’ll give that a try.