How to make a multivalue dropdown search criteria as mandatory in RDL reports
I am new to RDL. In my current application we have a report (we are using the report file with .rdl extension) with lot of filtering options (from date, to date and few dropdowns).
And the dropdown is loaded with a default value as <Select a value>.
When I try to perform search without selecting any valid option in the dropdown, it throws a error message something like value for the dropdown field/parameter is missing.
I reviewed the query which is being used for loading the values to the dropdown and noticed that it is returning only the data. I mean the <Select a value> is not returning from the DB. However, it's getting displayed in the aspx page.
I also searched for the <Select a value> in the entire code directory, but I couldn't find any files with this text.
I am not sure, how this value is getting assigned to the dropdown.
In short, the dropdown field/paramter is marked as a mandatory parameter with a default value. But I am not sure where the default value is getting assigned to the dropdown.
I have have misunderstood but I think the problem is that you have not defined a default value.
By design, for multi-value parameters, <select a value> is used as a placeholder if no values have been selected by default. You will not find it on your code anywhere, it's part of the drop down control.
Here's one of my reports that shows the exact same thing.
If you do not require defaults the you can leave this as it is, the warning you saw is correct as nothing has been selected.
If you do require defaults, then you can set these in the parameter properties.