Hello,

When I run this below code, I got the output with 1 sheet and 3 Tabs. When I burst the code from Reportcaster I am getting 3 sheets for ENGLAND . Is it possible can I get 1 sheet for each country instead of 3. I appreciate any one have suggestions...

 
TABLE FILE CAR
SUM RETAIL_COST
    DEALER_COST
BY COUNTRY
BY CAR
BY MODEL
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT XLSX OPEN
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
TYPE=REPORT,
     TITLETEXT='Country',
$
ENDSTYLE
END

TABLE FILE CAR
SUM RETAIL_COST
    DEALER_COST
BY COUNTRY
BY CAR
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT XLSX
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
TYPE=REPORT,
     TITLETEXT='Car',
$
ENDSTYLE
END

TABLE FILE CAR
SUM RETAIL_COST
    DEALER_COST
BY COUNTRY
BY MODEL
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT XLSX CLOSE
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
TYPE=REPORT,
     TITLETEXT='Model',
$
ENDSTYLE
END


 

This message has been edited. Last edited by: FP Mod Chuck,

Look up TOC in the doc.

https://webfocusinfocenter.inf...source/rc_tips97.htm

BabaKNYC, I tried the suggestion code in the document you gave me the link....I am still getting the 3 sheets instead of 1 sheet with tabs.

SET BASEURL=http://server1:8080/
SET COMPOUND=BYTOC
SET ONLINE-FMT=EXL2K
TABLE FILE GGSALES
SUM GGSALES.SALES01.UNITS/I08C
GGSALES.SALES01.DOLLARS/I08M
BY GGSALES.SALES01.REGION
BY GGSALES.SALES01.PRODUCT
ON TABLE SET PAGE-NUM OFF
ON TABLE SET BYDISPLAY ON
ON TABLE NOTOTAL
END

  

V_any

Which version are you using? I ran this in 8.1.05M and 8.2.01M and it gives me 1 sheet with multiple tabs.

Chuck Wolf,
We have Webfocus 8.2.01M. When I manually run the below fex I got the output in 1 sheet and the tabs. But when I schedule through Reportcaster it is putting in separate sheets.

 
SET BASEURL=http://server1:8080/
SET COMPOUND=BYTOC
SET ONLINE-FMT=EXL2K
TABLE FILE GGSALES
SUM GGSALES.SALES01.UNITS/I08C
GGSALES.SALES01.DOLLARS/I08M
BY GGSALES.SALES01.REGION
BY GGSALES.SALES01.PRODUCT
ON TABLE SET PAGE-NUM OFF
ON TABLE SET BYDISPLAY ON
ON TABLE NOTOTAL
END


 

quote:

A

I am on 8201M as well and in order for my compound excel documents to work (multiple tabs) I have to mark the "Override the Format Specified in the Procedure" and choose the format even though it is already in the procedure. I believe this to be a bug and still have to open a case to discuss with IBI but once I did that with your example it run fine otherwise I got no output.

Todd, we had to use your solution in v8.0.08 as well.