Forum Discussion
Dynamic Subscriptions and a Paginated Report with a multi-value parameter
There is an easy solution to this, have one report be customer facing where the use of the multi-value works as normal from the drop down parameter selection. Then have a subscription based version of the report where the multi-value parameter is essentially just text i.e. remove the check for multi-value, remove any defaults, etc. Then when you go to do a dynamic subscription just pass 'abcd, bcde, cdef' as a single string. This is assuming of course you are doing a STRING_SPLIT or using some kind of split function on the database side. This delivers a single file output to the user with all three values having been passed for their report run. I've seen postings where a dummy parameter is used and this allows for the report to work on demand and also in a subscription, but it's pretty awkward and very confusing. This seemed the simplest way to accomplish what was needed and I can train other developers on my team to handle this scenario the same way.