Complex Date Summary Reports

[lance123]

Hi To All,

Hoping someone has a smarter way of doing a multiple date range summary report. I have two fields which specify a date range. I then have fields which divide this range into days months or weeks depending on the user selection. I then use multiple relationships to grab and summarise data between the multiple date ranges. Ie 12 months = 12 ranges. It just all starts to get very laborious when trying to do 52 weeks!!

I don't want to use scripts all should be calcs. As I deploy this on the web.

Any ideas much appreciated.

Thanks,

Lance