Hi,

I have a report where I need to display dates (format Jan ,2009, Feb, 2009 .... Jan 2010 etc) in excel format

For example
1st report in the excel (Compound Report )will have

TABLE FILE CAR
PRINT CAR COUNTRY
END

2nd Report in the excel Same Sheet

TABLE FILE CAR
PRINT CAR COUNTRY
END

....

12th Report in the excel Same Sheet


TABLE FILE CAR
PRINT CAR COUNTRY
END

Thanks,

Ganesh

This message has been edited. Last edited by: Kerry,

Do you want in this way?

1st report in the excel (Compound Report )will have

TABLE FILE CAR
PRINT CAR COUNTRY
COMPUTE NEW_DATE/YYMD = UR_DATE_FIELD;
COMPUTE HIRE_DATE_PLUS_ONE_MONTH/YYMD = DATEADD(NEW_DATE, 'M', 1);
END

2nd Report in the excel Same Sheet

TABLE FILE CAR
PRINT CAR COUNTRY
COMPUTE NEW_DATE/YYMD = UR_DATE_FIELD;
COMPUTE HIRE_DATE_PLUS_ONE_MONTH/YYMD = DATEADD(NEW_DATE, 'M', 2);
END
..
12th Report in the excel Same Sheet


TABLE FILE CAR
PRINT CAR COUNTRY
COMPUTE NEW_DATE/YYMD = UR_DATE_FIELD;
COMPUTE HIRE_DATE_PLUS_ONE_MONTH/YYMD = DATEADD(NEW_DATE, 'M', 12);
END