The 'param1' parameter is missing a value
-
I've set a parameter to have
General - Allow multiple values
Available values - Get values from a query (KRP is in the list)
Default values - Get values from a queryI get
The 'param1' parameter is missing a value
Works fine.
Just prompts for blank param1
I want to create a URL that only picks from a few of the Available values.
-
That;s just not how SSRS works. When you supply a query for the available values, the default value can be supplied by a query, but that query must have only one row.
Steve (aka sgmunson)
Rent Servers for Income (picks and shovels strategy) -
Many thanks. I was slowly coming to that conclusion myself.
I have now added a duplicate parameter (@param2) that does not use available values but is part of the where clause with an OR
So I have changed SQL where clause from:-
where customer in (@param1)
To:
where customer in (@param1)
or customer in (@param2)This works as required. Just a faf! I can now just supply param2 in URL with out param1 and I get the data I want
Thanks
Kelvin
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply