Hi,
I have a report which has cascading parameters.Say Division,Region,Area,District.
I want to set the default values of the parameters so that if higher level say Division is not selected(blank) the lower level say Region should be blank but if the higher level is selected then it should give default value from the query.
I tried giving expression in the default value for region as
=iif(Parameters!SELECT_DIVISION.Value<>nothing,Parameters!SELECT_REGION.Value,nothing)
When I preview it is showing error occured during processing of region parameter.
Any ideas whould be higly appreciated,
Thanks