I will be very thankful for your advise.
I have report. If I run this report with
ON TABLE PCHOLD FORMAT EXL07 or with
ON TABLE HOLD AS aa FORMAT EXL07
Now I try to make compound excel. I have done template REP_AA07T.XLTX and template is in applications directory.
If I do report with
ON TABLE PCHOLD AS AA FORMAT EXL07 TEMPLATE REP_AA07T SHEETNUMBER 1
But I try to do hold to use more sheets. I do report
FILEDEF T1 DISK T1.XLTX
TABLE FILE REP
ON TABLE HOLD AS T1 FORMAT EXL07 TEMPLATE REP_AA07T SHEETNUMBER 1
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
And I am getting :
0 NUMBER OF RECORDS IN TABLE= 150 LINES= 35
0 XLSX FILE SAVED ...
And after that on next steps it will say that template T1 do not exist (as not created before).
What I am doing wrong?
p.s. wf 8007MThis message has been edited. Last edited by: <Kathryn Henning>,
Rather than using FILEDEF to pre-declare your interim hold files, use the file extension in the "hold name" - see the following working example.
-* File exl07_template.fex SET EMPTYREPORT = ON TABLE FILE CAR SUM RCOST DCOST BY COUNTRY BY CAR BY MODEL WHERE COUNTRY EQ 'ENGLAND' ON TABLE HOLD AS CAR1 FORMAT EXL07 TEMPLATE 'exl07_template.xltm' SHEETNUMBER 1 END -RUN TABLE FILE CAR SUM RCOST DCOST BY COUNTRY BY CAR BY MODEL WHERE COUNTRY EQ 'ITALY' ON TABLE HOLD AS CAR2 FORMAT EXL07 TEMPLATE 'car1.xlsm' SHEETNUMBER 2 END -RUN TABLE FILE CAR SUM RCOST DCOST BY COUNTRY BY CAR BY MODEL WHERE COUNTRY EQ 'W GERMANY' ON TABLE PCHOLD FORMAT EXL07 TEMPLATE 'car2.xlsm' SHEETNUMBER 3 END -RUN
Thank you Tony, your example works. Big thanks!
I cannot to use macros, so use XLTX file at step 1 and xlsx files after that. All works. Thanks.This message has been edited. Last edited by: Piter,
|Powered by Social Strata|