I am developing a report which has five set of cascading parameters. The requirement is user can select any of the parent parameter and its Child parameter respectively. If parent is not selected the Child will not get enabled(Cascading). The report should If any one of the parent is not selected. But i get an error as no value for that particular parameter. How do i make this work.

 

Your valuable suggestions are awaited!!!

 

Thanks

Is there anything by which we can handle it in formula's where this parameter is called..???

 

 

Thanks 

 

Dynamic Cascading parameters will not have Default values option to define default values.

 

If you are using any optional prompts in your report, you need to handle this in your record selection like ..

 

If Hasvalue({?Parameter}) then {fieldvalue} =  {?Parameter} else True

 

The above condition will check if your parameter contain value or not. If there is no values it will take all values in the above senario.