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

Posts: 68 | Registered: February 20, 2004

Tony A

Expert

posted

Hide Post

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