Report Builder 3 (12.0.500) Parameter Default Values - Get values from a query issue

Question

I have a report that is using stored procedures for all of the datasets. The main SP has two parameters (warehouse and Class) that are both 'allow multiple values', the available/default values come from SP queries. Been using SSRS for over 10 years now, but first time trying using the Default by query due to the long list of defaults required. Trying to make this easier to manage long term by putting these parameters in a table so that they can easily be changed by the end users. And I have a long list of reports to do this to.

Everything works just fine in Report Builder when I preview the report in Report Builder. The list of available parameters shows up and the appropriate parameters are selected. Report generates just fine. The issue is that when I look at the report on the Report Server, the list of available parameters is correct, BUT the default values are NOT selected.

Looked in the log, did not see anything useful. Tried changing the order of the datasets in case that mattered.

I am not finding help online and I have tried to format the question multiple ways...no joy. Please help and thanks in advance.

Answer 1

Hi @Monte Tisland

This sounds strange. The default worked fine in my tests.

Are you adding the parameters correctly? Have you added variables to the main dataset query? You can refer to this document: Add a multi-value parameter to a paginated report.

If everything is correct, try recreating the report to see if the same error occurs.

If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

Best regards,

Aniya