I checked the Excel Roadmap and according to that it says it's support in 8.1.03 and above. I am on 8.1.05 and I can't get it to work. Anyone else get it to work?

 

-SET &ECHO = 'ALL';

TABLE FILE CAR
SUM
   DEALER_COST
   RETAIL_COST
   SALES
BY COUNTRY
BY CAR
ON TABLE PCHOLD FORMAT EXL07
END
-RUN

 

This message has been edited. Last edited by: MattC,

Do you mean by using ON TABLE PCHOLD FORMAT XLSX BYTOC? Or via Report Caster?

T

Report Caster.

Yes, you should be able to select it within the list of formats available for format override.

Just tested and is OK

T

Interesting. Maybe something is wrong with my environment then. I get nothing.

 

    BTP1010         Schedule Executed On Demand at WDWBFV11:8200 (WDWBFV11/10.255.208.127)
    BTP1010         Job placed in the waiting queue at 2016-08-05 10:21:23.735-0400 (1,470,406,883,735)
    BTP1010         Job started running at 2016-08-05 10:21:23.888-0400 (1,470,406,883,888)
    BTP1010         Job remained in waiting queue for 0.153 seconds
    BTP1020         Starting task: Task 1
    BTP1020         Task type: EDA RPC
    BTP1020         Procedure name: matt/car_cntry
    BTP1020         Connecting to server EDASERVE with execution id mchap01 at 2016-08-05 10:21:26.275-0400 (1,470,406,886,275)
    BTP1020         Executing focexec.
    BTP1020         SET EXCELSERVURL = ''
    BTP1020         TABLE FILE CAR
    BTP1020         SUM
    BTP1020         DEALER_COST
    BTP1020         RETAIL_COST
    BTP1020         SALES
    BTP1020         BY COUNTRY
    BTP1020         BY CAR
    BTP1020         ON TABLE PCHOLD FORMAT XLSX
    BTP1020         END
    BTP1020         -RUN
    BTP1020         SET DISTRIBUTE=OFF
    BTP1020         -RUN
    BTP1020         Connection to the Reporting Server EDASERVE closed at 2016-08-05 10:21:30.491-0400 (1,470,406,890,491)
    BTP1020         Job ran on the Reporting Server EDASERVE for 4.204 seconds
    BTP1020         Task finished.
    BTP1010         Starting distribution: Email
    BTP1010         Distribution method: Email
    BTP1010         Retrieving distribution list from file
    BTP1010         Distribution finished.
    BTP1010         Job finished at 2016-08-05 10:21:30.580-0400 (1,470,406,890,580)
    BTP1010         Job time on distribution server after the report completed was 0.066 seconds
    BTP1010         Total running time was 6.692 seconds
    BTP1010         Total elapsed time (including the queue time) was 6.845 seconds



 

I get

Schedule Executed On Demand at 8105M-GEN22:8200 (8105M-GEN22/192.168.111.221) 
Job placed in the waiting queue at 2016-08-05 15:15:13.866+0100 (1,470,406,513,866) 
Job started running at 2016-08-05 15:15:13.867+0100 (1,470,406,513,867) 
Job remained in waiting queue for 0.0010 seconds 
Starting task: Task 1 
Task type: EDA RPC 
Procedure name: ee3cbec9_ddfb_4559_948b_24149484cf23 
Connecting to server EDASERVE with execution id admin at 2016-08-05 15:15:14.005+0100 (1,470,406,514,005) 
Executing focexec. 
Connection to the Reporting Server EDASERVE closed at 2016-08-05 15:15:14.409+0100 (1,470,406,514,409) 
Job ran on the Reporting Server EDASERVE for 0.4 seconds 
Task finished. 
Starting distribution: Email 
Distribution method: Email 
xlsx_bytoc_ENGLAND.xlsx distributed to xxxx.xxxx@xxx.xxx 
xlsx_bytoc_FRANCE.xlsx distributed to xxxx.xxxx@xxx.xxx 
xlsx_bytoc_ITALY.xlsx distributed to xxxx.xxxx@xxx.xxx 
xlsx_bytoc_JAPAN.xlsx distributed to xxxx.xxxx@xxx.xxx 
xlsx_bytoc_W GERMANY.xlsx distributed to xxxx.xxxx@xxx.xxx 
Distribution finished. 
Job finished at 2016-08-05 15:15:15.444+0100 (1,470,406,515,444) 
Job time on distribution server after the report completed was 1.027 seconds 
Total running time was 1.577 seconds 
Total elapsed time (including the queue time) was 1.578 seconds

T

The settings that I have for the task are -

T

Mine looks the same. Only thing I can think of is that my Distribution Server in on a different box from the client. I wonder if that is causing my issue.

Just out of curiosity, How does your distribution file look?

 
matt@CRAZY.COM,ENGLAND,$
John@CRAZY.COM,FRANCE,$


 

And thanks for the help.

Much the same although I tried single email and a content based distribution list. Where are you pulling your dist list from?

T

Just tested with external distlist (in the baseapp directory) and all worked OK

T

I am pulling from the server. Works fine with EXL2K. I opened a case. Hopefully I can get this working.

FYI

For us to get EXL07 and XLSX formats to work, we had to SET EXCELSERVURL=''

quote:

Originally posted by Waz:
FYI

For us to get EXL07 and XLSX formats to work, we had to SET EXCELSERVURL=''

That is true for us as well.

My environment was the issue. I was able to burst with my above example in my Production environment.

I have a suspicion that an upgrade versus a clean install caused my issue in DEV. Now that I have uninstalled and Reinstalled RC, it is all working now.

Thanks for all the help.