Need multi-value parameter labels in single comma-separated line

  • I've got a report that allows users to select mutliple SiteDepartments for which to return data. However, the dataset itself does not return SiteDepartment since the grouping of the returned data is at a higher level. I want to put a text box above the table that lists the SiteDepartments as a "reminder" to the user of which ones they chose. I have tried everything I can think of. I really want the values to be returned in a single line, separated by commas. The only thing I've gotten to work so far is to display my SiteDepartment parameter dataset (with a filter on the selected parameters) as a separate table above my report). I've tried using Multilookup with a split function, but every MS article I've found says you cannot use Multilookup with a report paramter. Any ideas?

  • It turned out I just need to use the Join function in SSRS!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply