Hi All

Creating report to replicate Excel Reports. User wants the report to exactly look like Excel Report.

Excel Report has Income row ACROSS YearMonths as following
Aug-12 Sep-12 Oct-12 ...
Income 999.99 999.99 999.99
..
..
In WF When I use I6YYMM it works fine in the same order as the excel report. I edited the field to make it look like the excel format.. but the order gets messed up see below

Apr-13 Dec-12 Feb-13 Jan-13 Jul-13 Jun-13 Mar-13 May-13 Nov-12 Oct-12

perhaps what is needed is smart date format which can display 3 Letter Month name with the two Digit Year.. The above I DEFINEd Month to 3 Letter Mon and concatenated with 2 position of the year. It looks same excel but ACROSS sorting is not matching..

Looked in the manuals and searched this site, did not come across this issue..

I thought I check with the Gurus here.

Thanks

This message has been edited. Last edited by: <Kathryn Henning>,

Add
ACROSS YearMonths NOPRINT

before your

ACROSS NewDefinedDateFormat

Worked. Thank You Martin