[Solved] Filtering by date inside a report
Greetings to all! I am trying to do something similar to this report in Report Designer:
However, I do not know the correct way to code the "Day" , "Month" and "Year" columns. I've tried several expressions returning an error, and being a newbie in Report Designer I'd appreciate some help. For example in the "Day" column I will need to display the sales completed today only. I used: "=FILTERIF((sum([ARTran.NetSalesAmount])-sum([ARInvoice.CuryDiscTot]))*0.835)<>[@Today]" , also tried using FILTER only instead of FILTERIF, and also tried multiplying the formula by [@Today], none of the options work. Please help!
I don't think you want to combine ARTran (the invoice line level) with ARInvoice (the invoice header level), but I'll use your fields to outline a technique that should work.
What about something like this?
=SUM(IIf([ARInvoice.DocDate]=@Today,[ARTran.NetSalesAmount]-[ARInvoice.CuryDiscTot],0)) =SUM(IIf([ARInvoice.DocDate]>=@MonthStart and [ARInvoice.DocDate]<=@MonthEnd,[ARTran.NetSalesAmount]-[ARInvoice.CuryDiscTot],0))