Focal Point
[SOLVED] EXL07 TEMPLATE CREATES 0 XLSX FILES

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6507030276

August 03, 2014, 01:34 PM
Piter
[SOLVED] EXL07 TEMPLATE CREATES 0 XLSX FILES
Hello,

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
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 8007M

This 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,


Wf7704/WF8,Win64/32