Hello All,
I have an odd report request that has come my way, and was just curious if anyone knew of a way to make this happen. The only parameter(s) for this report is to be essentially a list of lists. That is, anywhere from 1 to, say, 10 lists. I was wondering if anyone new of a way to have the normal list parameter pop-up allow a multi-select for lists. I tried a few things, but was unable to come up with a solution.
Worst case scenario, I will just go with like 10+ optional parameters for lists and then just bring them all together (multi-selecting lists from the normal multi-select dropdown is just UGH given the number of list options so not even a question). But I figured I would ask around first.
John
Hi John,
It looks like the pop-up only works if the parameter is a number/int type, not string. I've tried running a dummy report on multiple lists from a single dropdown and that works as expected. Perhaps you can persuade the users to either store the lists in a special folder or use a naming convention so you can add this as a filter in report setup?
Kevin
Thanks for getting back to me! I figured there was no way to really make it happen.
For the time being, I think I have just decided to go with 15 optional parameters. Though I like the idea of the special folder parameter, and might consider that as an option, depending on what reception this gets.