Focal Point
[SOLVED] Compound HTML report for RC in WF8?

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9247001576

March 12, 2015, 10:42 AM
Doug
[SOLVED] Compound HTML report for RC in WF8?
This is easy enough to do in PDF, the default. But, what needs to be done to create it as and HTML report? Or a single page styled report which can be distributed via ReportCaster? It should be simple, however, I'm sure that I'm missing something, somewhere?

This is the main COMPOUND Report:
-* Default Mode: ResourceLayout

*-HOLD_SOURCE
-* File sowss_stats_report_compound
SET HTMLARCHIVE=ON
COMPOUND LAYOUT PCHOLD FORMAT PDF
UNITS=IN, $
SECTION=section1, LAYOUT=ON, METADATA='prop_with_names^Margins_Left=0.5^Margins_Top=0.5^Margins_Right=0.5^Margins_Bottom=0.5^thumbnailscale=4', MERGE=OFF, ORIENTATION=PORTRAIT, PAGESIZE=Letter, SHOW_GLOBALFILTER=OFF, $
PAGELAYOUT=1, NAME='Page layout 1', text='Page layout 1', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, ORIENTATION=LANDSCAPE, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,ORIENTATION=LANDSCAPE,', $
COMPONENT='report1', TEXT='report1', TOC-LEVEL=2, POSITION=(0.500 0.917), DIMENSION=(10.000 0.500),  ARREPORTSIZE=DIMENSION, METADATA='Z-INDEX: 1; POSITION: absolute; WIDTH: 10in; HEIGHT: 0.5in; TOP: 0.917in; LEFT: 0.5in', $
COMPONENT='report2', TEXT='report2', TOC-LEVEL=2, POSITION=(0.500 1.417), DIMENSION=(10.000 0.500),  ARREPORTSIZE=DIMENSION, METADATA='Z-INDEX: 2; POSITION: absolute; WIDTH: 10in; HEIGHT: 0.5in; TOP: 1.417in; LEFT: 0.5in', $
COMPONENT='report3', TEXT='report3', TOC-LEVEL=2, POSITION=(0.500 1.917), DIMENSION=(10.000 0.500),  ARREPORTSIZE=DIMENSION, METADATA='Z-INDEX: 3; POSITION: absolute; WIDTH: 10in; HEIGHT: 0.5in; TOP: 1.917in; LEFT: 0.5in', $
COMPONENT='report4', TEXT='report4', TOC-LEVEL=2, POSITION=(0.500 2.417), DIMENSION=(10.000 0.500),  ARREPORTSIZE=DIMENSION, METADATA='Z-INDEX: 4; POSITION: absolute; WIDTH: 10in; HEIGHT: 0.5in; TOP: 2.417in; LEFT: 0.5in', $
OBJECT=STRING, NAME='text1', TEXT='<font face="ARIAL" size=18 color=#000080>Convert this to HTML from PDF.</font>', POSITION=(0.500 0.500), MARKUP=ON, WRAP=ON, DIMENSION=(10.000 0.500),  METADATA='Z-INDEX: 5; POSITION: absolute; WIDTH: 10in; FONT-FAMILY: ARIAL; WORD-WRAP: break-word; HEIGHT: 0.5in; COLOR: #000080; FONT-SIZE: 18pt; TOP: 0.5in; LEFT: 0.5in', $
COMPONENT='report5', TEXT='report5', TOC-LEVEL=2, POSITION=(0.500 2.958), DIMENSION=(10.000 0.500),  ARREPORTSIZE=DIMENSION, METADATA='Z-INDEX: 42; POSITION: absolute; WIDTH: 10in; HEIGHT: 0.5in; TOP: 2.958in; LEFT: 0.5in', $
END
SET COMPONENT='report1'
-*component_type report
-INCLUDE IBFS:/WFC/Repository/webdevel/Doug/BaseFolder/car_part1.fex
SET COMPONENT='report2'
-*component_type report
-INCLUDE IBFS:/WFC/Repository/webdevel/Doug/BaseFolder/car_part2.fex
SET COMPONENT='report3'
-*component_type report
-INCLUDE IBFS:/WFC/Repository/webdevel/Doug/BaseFolder/car_part3.fex
SET COMPONENT='report4'
-*component_type report
-INCLUDE IBFS:/WFC/Repository/webdevel/Doug/BaseFolder/car_part4.fex
SET COMPONENT='report5'
-*component_type report
-INCLUDE IBFS:/WFC/Repository/webdevel/Doug/BaseFolder/car_part5.fex
COMPOUND END

This is the the fex to be included 5 times as "car_part#.fex":
SET PAGE = NOPAGE
TABLE FILE CAR
SUM COUNTRY AS '' DCOST/D12.2M AS '' SALES/D12.2M AS ''
WHERE COUNTRY EQ 'ENGLAND'
ON TABLE SET STYLE *
SQUEEZE=OFF, GRID=OFF, FONT=ARIAL, SIZE=10, COLOR=NAVY, WIDTH=2,$
ENDSTYLE
END
I used this for each of the 5 countries. But, of course, for simplicity, just make one fex and include it multiple times.

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




   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
March 12, 2015, 01:33 PM
Doug
I got it... I don't see that COMPOUND HTML is doable via the composer. However, it is by using HTMTABLEs.