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] Compound Excel report not all on one tab
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Compound Excel report not all on one tab
 Login/Join
 
Platinum Member
posted
I have a compound Excel report and I want all the reports to be on one tab, but the first report is always on the first tab and the others are on the second tab. How do I get them to all be on the first tab?
I set up the compound report thusly:

SET HTMLARCHIVE=ON
*-HOLD_SOURCE
COMPOUND LAYOUT PCHOLD FORMAT EXL2K
UNITS=IN, $
SECTION=section1, LAYOUT=ON, METADATA='prop_with_names^Margins_Left=0.5^Margins_Top=.25^Margins_Right=0.5^Margins_Bottom=.25^thumbnailscale=4', MERGE=OFF, ORIENTATION=LANDSCAPE, PAGESIZE=Letter, SHOW_GLOBALFILTER=OFF, $
PAGELAYOUT=1, NAME='Page layout 1', text='Page layout 1', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, $
COMPONENT='report01', TEXT='report01', TOC-LEVEL=2, POSITION=(0.520 0.312), DIMENSION=(* *), ARREPORTSIZE=DIMENSION, $
COMPONENT='report02', TEXT='report02', TOC-LEVEL=2, POSITION=(-0.001 +0.127), DIMENSION=(* *), RELATIVE-TO='report01', RELATIVE-POINT=BOTTOM-LEFT, POSITION-POINT=TOP-LEFT, BYTOC=0, ARREPORTSIZE=DIMENSION,$
COMPONENT='report03', TEXT='report03', TOC-LEVEL=2, POSITION=(-0.001 +0.127), DIMENSION=(* *), RELATIVE-TO='report02', RELATIVE-POINT=BOTTOM-LEFT, POSITION-POINT=TOP-LEFT, BYTOC=0, ARREPORTSIZE=DIMENSION,$


And I have ON TABLE PCHOLD FORMAT EXL2K OPEN NOBREAK on the first report. What am I missing?

Thanks,
Deb

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


WebFOCUS 8.2.03 (production), 8.2.06 (testing)
AppStudio, InfoAssist
Windows, All Outputs
 
Posts: 162 | Location: Indiana | Registered: December 05, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
A guess (not tested), remove
quote:
BYTOC=0


BYTOC is normally used to create a "break" in the report display which is a new tab in Excel.


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2283 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Nice thought, MartinY, but it didn't work. I even tried removing the TOC-LEVEL parameters. Still getting two tabs. Frowner


WebFOCUS 8.2.03 (production), 8.2.06 (testing)
AppStudio, InfoAssist
Windows, All Outputs
 
Posts: 162 | Location: Indiana | Registered: December 05, 2017Reply With QuoteReport This Post
Platinum Member
posted Hide Post
I figured it out -- I removed the COMPOUND LAYOUT bit and just ran the reports with OPEN NOBREAK on the first and CLOSE on the last and that put them all on the same tab.
I've only done compound PDF reports before; I guess EXCEL is a bit different!


WebFOCUS 8.2.03 (production), 8.2.06 (testing)
AppStudio, InfoAssist
Windows, All Outputs
 
Posts: 162 | Location: Indiana | Registered: December 05, 2017Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Compound Excel report not all on one tab

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