I have report. If I run this report with ON TABLE PCHOLD FORMAT EXL07 or with ON TABLE HOLD AS aa FORMAT EXL07 report works.
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 report works
But I try to do hold to use more sheets. I do report
..... FILEDEF T1 DISK T1.XLTX -RUN
TABLE FILE REP .... ON TABLE HOLD AS T1 FORMAT EXL07 TEMPLATE REP_AA07T SHEETNUMBER 1 ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * ... ENDSTYLE END -RUN
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?
Thanks, Piter
p.s. wf 8007MThis message has been edited. Last edited by: <Kathryn Henning>,
August 04, 2014, 05:23 AM
Tony A
Hi Piter,
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
T
In FOCUS since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
WebFOCUS App Studio 8.2.06 standalone on Windows 10
August 04, 2014, 06:09 AM
Piter
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,