Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] EXL07 TEMPLATE CREATES 0 XLSX FILES
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] EXL07 TEMPLATE CREATES 0 XLSX FILES
 Login/Join
 
Gold member
posted
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, 2004Reply With QuoteReport This Post
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


T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.06 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5617 | Location: United Kingdom | Registered: April 08, 2004Reply With QuoteReport This Post
Gold member
posted Hide Post
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
 
Posts: 68 | Registered: February 20, 2004Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] EXL07 TEMPLATE CREATES 0 XLSX FILES

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.