I need to create a group based on the consecutive calendar days in a year....these values must be derived since no single data field is provided that will cover all values. There are paydates available from each of the datasources I have linked, but In order to group the debits and expenses by month, I think I need a constant value to group by so that as each paydate is encountered the appropriate amounts will populate based on a paydate - to - calendar date match.
Seems simple to just group by paydate, but fiscal year runs July-Jun....not the same as a calendar year...so I'm using multiple sources. I have been able to work out multiple groupings using counter fields to determine what to hide and what to sum....but because of the repetition for each group it takes forever to run. I'm also running into some difficulty when finding my totals for the 3rd group.
Technically, each calendar date should be a new entry in the group and display even if empty. I will use the section expert to hide the empty rows afterwards.
Thank you in advance!!