I am stuck on how to proceed to meet my clients requirements, all help and suggestions very much welcome!.
I am trying to create a Customer Statement report:
Date field : Invoice Due date - datatype - DateTime.
The approach I am taking to be have all open Invoice listed in the main body of the reports and in the report footer, I am inserting subreports to summary the status of the customers account : ie Current, 1 Month, 2 Month
The sub-reports are displayed within the report footer.
1st Subreport : Current, meaning within the current Month
Current =
If {OINV.DocDueDate} >= MonthToDate then
"Current"
This part is working fine.
2nd Subreport : 1 Month, meaning docduedate is within 1 month prior to current month
I tried using the following :-
If {OINV.DocDueDate} in Aged0To30Days then
"1 MONTH"
Unfortunately I have a duplicated in my results:
Records with a date between 1-7 Nov are appearing in subreports 1 &2
Suggestions please!