I need a method to paste insert multiples (such as part numbers) into a parameter. Is there a way to do this in a report or dashboard? I know “list” doesn’t work on this method or at least I can’t figure it out. Seems as though I recall Crystal Reports had this option. We are trying to move away from crystal reports to SSRS.
I see what you mean. The BAQ List parameter does not allow copy/pasting a list from Excel. Is that the functionality you’d like?
Yes. That is what we need. Typing in 100+ part numbers is not an option.
1 Like
I know for reports you can map a parameter to a filter in the RDD. Then you can paste/insert into the filter grid on the report. Not sure for a dashboard. Might need to get creative, there. Does it have to have a parameter? For example, you can load a dashboard without auto-loading the results. Then make a filter tracker that has mandatory inputs (to prevent it from being run wide-open). We’d still have to figure out how to get the right input there that would accept a paste/insert so it could filter properly, though.
Another angle, what generates this list of part numbers? Is it just someone’s manual list? Is it a list of parts that is dependent on some other function? Could you search out that list of parts in your BAQ and then you could filter the main BAQ with that subquery?
I’m digging on this as well. Even mapping my parameter to a filter doesn’t seem to work though. Still gives an error that I’m basically rewriting over the same value over and over instead of adding the whole list.
The old crystal report had this feature.