Filter using OR instead of AND.

[Michael]

I have 3 report parameters. 

Fields.InvYear,

Fields.InvMonth,

Fields.InvQtr

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,

[Michael]

I solved this issue by just making the month multi-select, which is a work-around. I would still like to know how to use an OR between report parameters versus AND.

[Todor]

Hi Michael,

Indeed, you may combine the filtering Expression only with the 'And' operator. The reason is that it is not clear what would be the precedence if we had both 'And' and 'Or' operators.

The workaround is to utilize a single Expression. For example:

Expression																	|	Operator	|	Value
=(Fields.InvQtr = Parameters.Quarter.Value) Or (Fields.InvMonth = Parameters.Month.Value)	|	=		|	=True

Regards,
Todor
Progress Telerik