Hello,

Im trying to develop a new report in HTML format using WF Dev Studio 8005, The report has 3 sub-reports

Header Report
Summary Report
Detail Report

I would like to enable paging just for the 'Detail Report'. However when I set 'On Demand Paging' ON for the last report, it repaints the screen and overwites the Headre and Summary sections. Appreciate any suggestions you may have on this.

Thanks!

This message has been edited. Last edited by: <Kathryn Henning>,

If you use HTMTABLE to hold and HTMLFORM to display all 3 reports in one screen, then add iframe in the HTMLFORM to make a separate call to detail report. Hope this helps.

Ram,
Thank You so much for the response. I used ALPHA format for holding the data. Also included my code below for your review.
If possible can you please share the syntax on how to print a HOLD file in an iframe.

Appreciate your Help.

Thanks
Hima

............
SET HOLDLIST=PRINTONLY
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS R5600DTL FORMAT ALPHA
END
-RUN

TABLE FILE R5600HD
PRINT
R5600HD.R5600HD.CALC_PERIOD
R5600HD.R5600HD.SALES_ID
R5600HD.R5600HD.SALES_OFFICE
R5600HD.R5600HD.DETAIL_TITLE OVER
R5600HD.R5600HD.CHANNEL OVER
R5600HD.R5600HD.REGION
R5600HD.R5600HD.MGR_ID
ON TABLE SUBHEAD
"SOV Audit and Compensation Details"
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET WEBVIEWER ON
ON TABLE SET WEBVIEWTARG OFF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/MYCLM/_EDAHOME/ETC/endeflt.sty,
$
TYPE=REPORT,
LINES-PER-PAGE=20,
ARGRAPHENGINE=JSCHART,
ALLOW-TOOLS=OFF,
HFREEZE=ON,
$
TYPE=DATA,
COLUMN=N1,
JUSTIFY=CENTER,
$
TYPE=REPORT,
COLUMN=N7,
WRAP=6.000000,
$
TYPE=REPORT,
COLUMN=N4,
WRAP=6.000000,
$
TYPE=REPORT,
COLUMN=N3,
WRAP=6.000000,
$
TYPE=REPORT,
COLUMN=N2,
WRAP=6.000000,
$
ENDSTYLE
END
TABLE FILE R5600DTL
SUM
R5600DTL.R5600DTL.VALIDATED_ORDER_VALUE
R5600DTL.R5600DTL.NET_ORDER_VALUE
BY LOWEST R5600DTL.R5600DTL.MGR_NAME NOPRINT
BY LOWEST R5600DTL.R5600DTL.SALES_ID

ON R5600DTL.R5600DTL.MGR_NAME SUBHEAD
"ON TABLE SET PAGE-NUM NOLEAD
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET WEBVIEWER ON
ON TABLE SET WEBVIEWTARG OFF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/MYCLM/_EDAHOME/ETC/endeflt.sty,
$
TYPE=REPORT,
LINES-PER-PAGE=20,
ARGRAPHENGINE=JSCHART,
ALLOW-TOOLS=OFF,
$
TYPE=DATA,
COLUMN=N1,
BACKCOLOR='NONE',
$
ENDSTYLE
END
TABLE FILE R5600DTL
PRINT
R5600DTL.R5600DTL.SALES_ID
R5600DTL.R5600DTL.SALESREP_NAME
R5600DTL.R5600DTL.CUSTOMER_NAME
R5600DTL.R5600DTL.OPPTY_ID
R5600DTL.R5600DTL.OPPTY_NAME
R5600DTL.R5600DTL.COMP_DATE
R5600DTL.R5600DTL.OPPTY_CLOSED_DATE
R5600DTL.R5600DTL.NET_ORDER_VALUE
R5600DTL.R5600DTL.VALIDATED_ORDER_VALUE
ON TABLE SET PAGE-NUM OFF
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET WEBVIEWER ON
ON TABLE SET WEBVIEWTARG OFF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/MYCLM/_EDAHOME/ETC/endeflt.sty,
$
TYPE=REPORT,
GRAPHCOLOR='GREEN',
GRAPHCOLORNEG='RED',
$
TYPE=REPORT,
LINES-PER-PAGE=50,
ARGRAPHENGINE=JSCHART,
ALLOW-TOOLS=OFF,
HFREEZE=BOTTOM,
$
TYPE=REPORT,
COLUMN=N3,
WRAP=6.000000,
$
TYPE=REPORT,
COLUMN=N2,
WRAP=6.000000,
$
ENDSTYLE
END