0

I'm using the new Report Builder for SSRS in SQL Server 2019, and I'm trying to create a paginated report with one multi-value parameter.

I've given my report two datasets, both from the same shared Data Source. One data set is all the report data, and the other just return as distinct list of keys from the first dataset.

Both queries run and return their expected values in the query designer. However if I create a multivalue parameter and set the available values to a field in that query. I get a blank list every time, and the entire report is also blank, even though I don't have the report configured to do anything with that parameter yet.

Parameter Settings

enter image description here

enter image description here

What am I missing? I am using the same cached sql login on the report, data source, and datasets, and the query definitely returns values.

If I remove the parameter from the report, then everything works as expected.

Whistler
  • 174
  • 6
  • How many values would you say are returned by the parameter data set? Could it be that it's a lengthy list and it's thinking before returning values? – BJones Dec 10 '19 at 16:22
  • about 2500, but even it I change the query something dead simple that only returns two values, It does the same thing – Whistler Dec 10 '19 at 16:35
  • Did you try deleting the parameter and creating again? Maybe delete, recreate using smaller data set, if that works then plug in the larger. – BJones Dec 10 '19 at 16:39
  • still no. Even if I make a dataset whose query is SELECT 'TEST VALUE' AS VALUE – Whistler Dec 10 '19 at 17:54
  • In the second dataset's query, are you referencing a parameter derived from the first dataset? – BRW Dec 10 '19 at 23:07
  • Just a hunch, have you tried creating default values for the parameter just to test that the data is actually passing through? Sometimes with default values, I have to set the first default to an expression to get it to pass the parameter. – Adam Dec 12 '19 at 09:48
  • the default is set to the same dataset, because the default needs to be all selected – Whistler Dec 12 '19 at 16:44

0 Answers0