February 22, 2018 at 11:17 am
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 query
I 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.
February 26, 2018 at 8:09 am
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)
February 26, 2018 at 9:09 am
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply