Skip to Content
0
Former Member
Nov 28, 2011 at 10:28 PM

crystal report display

29 Views

There are 2 fields in my report. One is the month number and the other one is a year.

fiscal year starts in June. So we are in fiscal month 6 and fiscal year 2012 now.

I have these 2 fields in the crystal report and I need to create a formula ,

that will display the Oct12 And then I need to supress the year - 12 . I might have fiscal year 2011 also in my dataset so it needs to be sorted in ascending order) , Right now it just displays as '5 2012'

. It needs to display as Oct

So I created a formula to convert number number to name: =Month(ToDate(FormatNumber([month_no];"00") ;"MM"))

BUt that gives an error in the version of Crystal report that I am using.