January 18, 2016 at 1:41 pm
My report has 2 drop down lists.
Both drop down lists have parameters properties selected for "allow ultiple values"
Now my report runs only if I select values from both drop down lists.
How do I make this work where even if I select 1 value or all 10 values out of 10 values from 1 drop down list and select nothing from the 2nd drop down list my report shouls still return a result and vice versa i.e I select 1 value or 10 values from 2nd drop down list and select nothing from the first drop list the result should fetch something.
As of now it is throwing a "Please selct value for the parameter "xyz"
I should be able to select null from both drop list which should result zero rows as result.
Or select null from 1st drop down and select from 2nd or select null from 2nd and select from 1st which should giv some result rows.
My actual dataset has an OR condition.
January 18, 2016 at 9:22 pm
You cannot "allow multiple values" and "allow null". What you can do however is create the option by adding an option to your list of values called "Nothing" or "Null". If you are specifying the values manually just add that as an option and handle it as needed in your report stored proc.
If you are using a query to populate your drop-down then add UNION ALL and another SELECT to add the "Nothing" option to the resultset, and again, handle that in your report stored proc as needed.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
January 18, 2016 at 10:24 pm
But how do I make the 2 drop down list independednt of each other.As of now I have select atleast 1 option in both the drop down lists to get a result set.
January 18, 2016 at 11:31 pm
Set a default value for both.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply