I have 3 report parameters.
I have 3 corresponding filters:
= Fields.InvYear = = Parameters.Year.Value
= Fields.InvMonth = = Parameters.Month.Value
= Fields.InvQtr = = Parameters.Quarter.Value
The year parameter is required, however I want the user to be able to pick either Month or Quarter. Even if I allow NULL or blank on the Month or Quarter parameters, Telerik says the parameters are required. The filters are hard coded to be AND, which should not make a difference if one of the parameters is blank. How do I create a "blank" entry?
My SQL fields:DATENAME(YEAR, Invoice.DateCreated) AS InvYear,
DATENAME(MONTH, Invoice.DateCreated) AS InvMonth,
DATENAME(QUARTER, Invoice.DateCreated) AS InvQtr,