I'm trying to print a report based on the previous month's results.
The report should look something like this.
DAY Column
1 10.30
2 200.70
3 300.10
..
31 40.90
total (1..31)
It needs to find the last historic entry created for that object on that day and so.
The record selection is based on recordtime. (needs to take into account months with 30 days etc.. If no entry is found for a date we need to default 0.
Thank You in advance
The report should look something like this.
DAY Column
1 10.30
2 200.70
3 300.10
..
31 40.90
total (1..31)
It needs to find the last historic entry created for that object on that day and so.
The record selection is based on recordtime. (needs to take into account months with 30 days etc.. If no entry is found for a date we need to default 0.
Thank You in advance