Hi all,
I needed a clear button for the report parameters and I followed the suggestions I have found on the internet and created a textbox linked the report.
The report has three cascaded parameters and a procedure is called using the last parameter(@c), which is populated using either of the first ones (@a and @b-2).
When the report is loaded with the default parameters the clear button works. Also after selecting all parameters. But if I have only one or two parameters selected I receive the message: Some parameters or credentials have not been specified. The linked report is called with no parameters and it should load the report with the default ones(null is the default value for @a and @b-2 parameters and all values for @C).
Do you have any idea why this happens?
Thank you