Crystal 2008 - Convert fiscal year to calendar year
Posted on 2014-02-27
Our fiscal year starts in June and ends in May. The GL_Data table in our ERP database has a year field and has monthly credit and debit fields.
The field names are: gl_year,debits@1, credits@1, debits@2, credits@2 and so on.
I want to be able to run this report from January 2013 to December 2013.
This would be for periods 8-12 for FY2012 and periods 1-7 in FY2013.
I need a way to set up an automatic report with date ranges set via parameters.
We know we need to group by year, but that groups by fiscal and does not show us true Calendar year data.
This is an example of what I have
gl_year debits@1 credits@1 debits@2 credits@2 debits@11 credits@11 debits@12 credits@12
2012 7 4 20 3
2013 10 5 22 15
and the results I need
April 2013 - 3
May 2013 - 17
June 2013 - 5
July 2013 - 7
Thank you for you help,