Hello, I have an SSRS report that uses a stored procedure. The stored proc is configured as a dataset, and one of the parameters is named @ProductNumbers. It is mapped to a report parameter of the same name, and if you clicked on expressions, it will indicate =Parameters!ProductNumbers.Value
The report parameter @ProductNumbers is fed from a dataset query for its available values, configured as text, and allows multiple values. So, it’s a dropdown on the report. It appears that this parameter is submitting a comma separated list of product numbers to the stored proc parameter, as it should.
This all works great, but now I need to add an additional report parameter to capture a handful of other product numbers to submit to the stored procedure that are not included in the @ProductNumbers report parameter dropdown. So, the user would just paste in a handful of comma separated product numbers in this additional text box parameter.
I was thinking about going to the stored proc dataset properties, parameters section, expression for @ProductNumbers and doing something like this:
=Parameters!ProductNumbers.Value & Parameters!NewTextBox.Value
Would this work? If so, what would be the correct syntax? Note that I cannot change the stored proc in this case. Help/suggestions appreciated.