Custom Group Header across fiscal periods
Posted on 2008-06-19
I am grouping data across a fiscal year. I took a date (discharge) and used a formula to calculate an effective fiscal year like this month(disch_date) > 9 then fyear=dyear+1, else fyear=dyear.
I can group them just fine by period they belong to, but I am trying to create a custom header that takes a parameter into account. The parameters are a start and date range to group data by. I need the header to take these into account when reporting.
scenario 1) range doesn't cross fiscal period.
8/15/07-9/15/07 then header reads 8/15/07-9/15/07
scenario 2) range crosses fiscal period
8/15/07-11/15/07 then group one header reads 8/15/07-9/30/07
group two header reads 10/1/07-11/15/07