Focal Point
Please help on page-break between reports

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

April 20, 2004, 04:55 PM
<Vipul>
Please help on page-break between reports
I need to specify page break(s) between compound reports...please help. I am attaching the sample code below:

I need page-break after each report...

-* File carhtmlform.fex
-SET &CNTR = 1 ;
-SET &OLDCOUNTRY = ' ' ;
-LOOPBACK
TABLE FILE CAR
SUM DST.COUNTRY NOPRINT
BY COUNTRY NOPRINT
WHERE COUNTRY GT '&OLDCOUNTRY'
IF RECORDLIMIT EQ 1
ON TABLE SAVE
END
-RUN
-READ SAVE &COUNTRY.A10. ;
-TYPE &COUNTRY
-SET &OLDCOUNTRY = IF &OLDCOUNTRY NE '&COUNTRY' THEN &COUNTRY ;
-TYPE &OLDCOUNTRY
-IF &LINES EQ 0 THEN GOTO NEXTSTEP;

TABLE FILE CAR
PRINT COUNTRY
CAR
MODEL
SEATS
SALES
RETAIL_COST
DEALER_COST
WHERE COUNTRY = '&COUNTRY'
HEADING
"Car Details"
ON TABLE HOLD AS PYDYCBO1 FORMAT HTMTABLE
ON TABLE SET STYLE *
TYPE=HEADING, LINE=1, STYLE=BOLD, COLOR=BLUE, $
-INCLUDE STYLEV01IR.FEX
ENDSTYLE
END

-HTMLFORM BEGIN
!IBI.FIL.PYDYCBO1;
-HTMLFORM END

-GOTO LOOPBACK
-NEXTSTEP
TABLE FILE CAR
PRINT COUNTRY
CAR
SALES
RETAIL_COST
DEALER_COST
HEADING
"Car Details #2"
ON TABLE HOLD AS PYDYCBO4 FORMAT HTMTABLE
ON TABLE SET STYLE *
TYPE=HEADING, LINE=1, STYLE=BOLD, COLOR=BLUE, $
-INCLUDE STYLEV01IR.FEX

ENDSTYLE
END

-HTMLFORM BEGIN
!IBI.FIL.PYDYCBO4;
-HTMLFORM END


Thanks,

Vipul
April 21, 2004, 09:21 AM
<Grzegorz>
Vipul,

You can try to experiment with something like:


...
COMPUTE BREAK_BEGIN/A42 = '
'; NOPRINT
COMPUTE BREAK_END/A6 = '
'; NOPRINT
WHERE COUNTRY = '&COUNTRY'
HEADING
"...

Note: the HTML/CSS page break is invisible in browser, it affects only printing. You can use some tag like HR to emulate multi-page HTML report.

Hope this helps
Grzegorz

This message has been edited. Last edited by: <Mabel>,
April 21, 2004, 09:22 PM
<Vipul>
That worked but I am sure they will like to see the page break on screen also.

Thanks
Vipul
April 28, 2004, 01:55 PM
<Pietro De Santis>
Vipul,

You may like to take a look at this:

http://www.blooberry.com/indexdot/css/properties/print/pbbefore.htm

It shows you hot to create page breaks for printing purposes for HTML files in Internet Explorer.

Pietro.
April 30, 2004, 04:00 PM
susannah
Pietro, what a great site! thanks!~
May 03, 2004, 07:55 PM
<Vipul>
Thanks Peter,

Somehow I am not allowed to access the website at work. i will do so from home.

Regards,

Vipul