I have a report which I need to send to a customer every weekday using a subscription, but without having to re-set report parameters each day.
The report contains satellite 'phone call records; we receive and process the data daily and pass the information on to the end-user.
The data has built up for the first month and will continue to build. However, I don't want to send him every call record every time, but use 'rolling' date parameters instead. The most useful approach would be to send the full month to date up to the last day of the month. At the beginning of the new month I also want to include the new month calls plus the old month up to a certain date. After that date, I want to only include the new month.
For example...
To 31st October - all October records to date.
1st - 10th November - all October records, plus Novemer records to date
11th November - only November records.
Hope that makes sense? Can anyone help with the best approach to solve this?
Thanks!
The report contains satellite 'phone call records; we receive and process the data daily and pass the information on to the end-user.
The data has built up for the first month and will continue to build. However, I don't want to send him every call record every time, but use 'rolling' date parameters instead. The most useful approach would be to send the full month to date up to the last day of the month. At the beginning of the new month I also want to include the new month calls plus the old month up to a certain date. After that date, I want to only include the new month.
For example...
To 31st October - all October records to date.
1st - 10th November - all October records, plus Novemer records to date
11th November - only November records.
Hope that makes sense? Can anyone help with the best approach to solve this?
Thanks!