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
WF 7.7.02 on Windows 7
Teradata
HTML,PDF,EXCEL,AHTML