Hi Everyone,

I have a requirement that a report when generated must be saved to the file system as well as sent to the end user. Since this is something that must be done across all reports I decided to create two fex(es) one to create the report and the other to do the output. I am wondering if there is a better way to do this since it requires 3 I\O operations I think; one to create the REPORT_NAME file, one to save the file to the specified location and another to send the file back to the user.

---report.fex---
-* File report.fex
-SET &ECHO=ALL;
-DEFAULT &REPORT_NAME = carrpt
-DEFAULT &REPORT_EXT = .xls

TABLE FILE CAR
BY COUNTRY
ON TABLE HOLD AS &REPORT_NAME
END
-INCLUDE output.fex

---output.fex---
-SET &ECHO=ALL;
-SET &DIRECTORY = 'C:\MYREPORTS\';
-SET &FILENAME = &REPORT_NAME.EVAL | &YYMD | &TOD | &REPORT_EXT;
-DOS mkdir &DIRECTORY

TABLE FILE &REPORT_NAME
PRINT
*
ON TABLE NOTOTAL
ON TABLE SAVE AS &DIRECTORY&FILENAME FORMAT EXCEL
END

TABLE FILE &REPORT_NAME
PRINT
*
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXCEL
END


Thanks!
Manish

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

i think your approach is perfectly reasonable. your first extract is the principal data one, and your 2nd two are alterate formats. works for me.

Also look into this -

TABLE FILE &REPORT_NAME
PRINT *
ON TABLE NOTOTAL
ON TABLE HOLD AS &DIRECTORY&FILENAME FORMAT EXCEL
END
PCHOLD FORMAT EXCEL

This just reuses the internal matrix rather than reprocess the entire request again.

T

This message has been edited. Last edited by: Tony A,

ah.sweet

And if you don't want to reread the internal matrix, then:

FILEDEF MYREPORT DISK &DIRECTORY&FILENAME 
TABLE FILE &REPORT_NAME
PRINT *
ON TABLE NOTOTAL
ON TABLE HOLD AS MYREPORT FORMAT EXCEL
END
-RUN
-* Return the file
SET HTMLFORMTYPE=XLS
-HTMLFORM MYREPORT