Hi,
I have a report in which we have seven parameters for filtering the report data. If I clicked on any of the dropdowns without selecting any option, first it refreshes all the dropdowns and then I clicked on any other dropdown, then it shows blank data in the next dropdown. In between, I have not performed any other operation. Here I am attaching the screenshots of it.
Please provide a solution for this
The Report Parameter is processed as a whole entity. Its evaluation starts after all its dependencies, for example, other Report Parameter values have been evaluated. If, for example, the Text property is set with an Expression that can be evaluated and the Value property depends on another Report Parameter, which value is unknown/invalid, neither the Text, nor the Value property will be set.
The same goes for the AvailableValues, if they depend on another report parameter, in order to be evaluated a valid value should first be set to the report parameter that this report parameter depends on. In your case, this is the Centre report parameter.
For more information, please see Cascading (dependent) parameters.
If you would need further assistance, please send us the report alongside some sample data for local investigation.