I have a report summarising invoice totals for today, the past week and the past month. Unfortunately, if an invoice is highlighted in in the Invoice List, the report picks that up a the data source, so ignores the in-built filters for dates. How do I prevent the report from picking up highlighted invoices and solely use the report's filters for the date range ?
It's got to be a setting in Report Designer but I can't spot it and google search doesn't help.
Thanks. Dave