When applying filter report gives: the request has multiple errors.

[nancysinghal]

I want to display the data for the user selected month and three previous months data.
The filter I applied is:

to_char([IEDSS Reporting].[Comprehensive Performance Metrics Summary Report].[As of Date],'Mon-YYYY') between _add_months (?Par_Asofdate?,-3) and
?Par_Asofdate?

When I validate the filter, it gives no error, but on running the report, it says , the request has multiple errors.

Any suggestions please.

Thanks,
Nancy

[BigChris]

First step is to disable the filter then run the report again...if you still get the multiple errors you'll know that the problem isn't with the filter.

[Michael75]

This is almost certainly a problem of incompatible data types. I guess your 'Mon-YYYY' contains values like 'DEC-2015'. And if you're doing an _add_months on your parameter, it will be of type date. You cannot compare the two, and some workaround will be needed, maybe by doing a cast. First of all, we need to know what is the format of your ?Par_Asofdate?.

[Lynn]

I want to display the data for the user selected month and three previous months data.
The filter I applied is:

to_char([IEDSS Reporting].[Comprehensive Performance Metrics Summary Report].[As of Date],'Mon-YYYY') between _add_months (?Par_Asofdate?,-3) and
?Par_Asofdate?

When I validate the filter, it gives no error, but on running the report, it says , the request has multiple errors.

Any suggestions please.

Thanks,
Nancy

The to_char function returns a character string. The _add_months function returns a date. Your filter should compare a dates with dates or strings with strings. You can't mix and match.

Try getting rid of the to_char function and see what happens.

Michael75 is on the same track as I am....and posted more quickly!