Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Don't major in minor things
 
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!

13
May

How Do I Sort by Financial Year?

During a recent SQL Server Reporting Services 2008 report writing project, my client wanted the budget vs actuals charts and matrix months sorted by financial year instead of calendar year.

Solution:

As I prefer to do as much as my manipulation within my SQL statements, rather than in SSRS, I created the following calculated field:

Case When MonthNo >= 4 then MonthNo - 3 else MonthNo + 9 end as FYSort

I can then use this field to control the sort order of the various items of the report



If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us

MAKE A COMMENT

Name *

Email Address *

Comment *

To prove you are human what is:

59 + 17 =