I am working on supplier report.
I have main report that is grouped by suppliers then by Customers.
I am showing parallel: This year month – last year month sales, this year Quarter last year same quarter sale and This YTD sales and Last YTD sales. Report has date parameter for picking month for report to run. Report is working ok.
User asked mi to put simple string parameter “Yes , “No” in report that will give him option to select only customers that had invoices that are older than 2 Years-- (that he was customer not just recently but two years and more before).
I was thinking how to do that.
One way is to create sub report that will show only customers that have Invoices older that two years and then use this sub report customers as filter for main report.
I need some help with details how to arrange this.