I'm working for an Indian client whose calendar year is from April<Previous Year> to Mar<Current Year>. Now in reports, I've below two requirements:
1. Display Calendar Day as DD.MM.YYYY instead of default 0CALDAY settings (i.e. MM/DD/YYYY).
2. In a report, I want to summarize Qty figure as per indian calendar e.g. if User runs report for last three years (i.e. for 2008, 2009 and 2010), then the report should summarize as per below:
a. April.2007 to Mar.2008
b. April.2008 to Mar.2009
c. April.2009 to Mar.2010
How can I achieve above two requirements.