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
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.
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?.
Quote from: nancysinghal on 09 Dec 2015 04:15:01 AM
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!