Several optional parameters, but at least one required

[Ken]

Hello,

 I have a report with optional parameters, but at least one needs to be specified to run the query (stored proc).

FromDate (Required)
ToDate (Required)
Invoice (Optional)
PurchaseOrder (Optional)
Customer (Optional)

 In this case, either Invoice, PurchaseOrder or Customer must be specified. I don't want the query to run if none of these are specified so right now I throw an exception from the stored proc if all are null, but this results in a non-user-friendly error message.

Thank you

[Nasko]

Hello Anders,

Using the built-in properties of the report parameters (during report you are able to configure one or more parameters to be required by setting their AllowNull and AllowBlank properties to False.
However, these properties do not offer an option to make a group of parameters required e.g., at one parameter of the whole group to have a value. Thus, in order to achieve the described effect, you will need to hide the default report parameters area (set Visible = False for all report parameters) and implement your own custom parameters UI and validation in your application.
After the values from the custom UI have been validated, you can pass them via the Report Source to the report.

Regards,
Nasko
Telerik