Skip to Content
0
Former Member
Jul 09, 2015 at 02:35 AM

How to provide date range filter in a summary report, if any 'Date' field is not showing in report?

245 Views

Hi,

I need to provide a date range filter for Say 'Order Date' , but I need not to show 'Order Date' in report; its just a summary report to show the number of records in that selected period , I created the 'DateRange' parameter, but unable to use it in either 'Query filter' or 'Interactive fiter'.

If I add that field 'OrderDate' in my report (which is wrong, as not required to show here), I can see it in 'Interactive filter', but still when I say 'OrderDate' is equal to 'Date Range parameter', its still not showing any data?

OR

How to add 'Date range parameter' in Query filter?

Thanks,

Poonam