Focal Point
[CLOSED - NFR] EXL07 Print Page Break

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

May 31, 2017, 12:37 PM
tomatosauce
[CLOSED - NFR] EXL07 Print Page Break
Hi All, I am facing a continuity problem for one of my EX07 report while printing. My Report format is as follows.

  
 <Header>
<Subhead1>
<row1>
<row2>
<subtotal1>
<subfoot1>
<subhead2>
<row1>
<row2>
<subtotal2>
<subfoot2>
.
.
.
<subhead20>
<row1>
<row2>
<subtotal20>
<subfoot20>
<Footing>

While printing certain subhead section is panning across two pages like below.
<page1>
<header>
<Subhead1>
<row1>
<row2>
<subtotal1>
<subfoot1>

<Subhead2>
<row1>
<row2>
---end of page


<page2>
<subtotal2>
<subfoot2>
<footer>

But i need something like this
<page1>
<header>
<Subhead1>
<row1>
<row2>
<subtotal1>
<subfoot1>
---end of page

<page2>
<Subhead2>
<row1>
<row2>
<subtotal2>
<subfoot2>
<footer>
--end of page

FYI - Certain pages may have more than 3 or four Subhead's depending on the number of rows for that sort field.

I have tried NOSPLIT , SET PRINTPLUS=ON but couldnt figure out to skip the Subhead section for sort field to next page if it doesnt fit in the current page. ANy suggestions would be helpful.

I couldnt do PAGE-BREAK because i dont want the header and footer to be printed on each and every page. Any help is appreciated. Thanks

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


Tharun Katanguru
SBOX- 8205 DEV/TEST/PROD : 8105 8205
Linux, All Outputs
May 31, 2017, 02:58 PM
MartinY
It's not clear for me.

Is it a printing issue (when printing Excel report on paper) or a report formatting issue (visual layout of the report) ?

Using PAGE-BREAK is probably the best option. But it won't solve a print issue on paper. You need Excel page-break not a Focus page-break.

You can also use Report Heading/Footing instead of Page Heading/Footing as follow if this can solve your issue:
[code]
TABLE FILE CAR
PRINT CAR
BY COUNTRY

ON COUNTRY PAGE-BREAK

ON TABLE SUBHEAD
"Report Header"

HEADING
"Page Header"

FOOTING
"Page Footer"

ON TABLE SUBFOOT
"Report Footer"

ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
ENDSTYLE
END
[code]


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
May 31, 2017, 04:48 PM
tomatosauce
MartinY,

It is a printing issue (When printing Excel Report on Paper).

As you said, I need a Excel Page Break (probably a macro that checks for the number of records in a sheet and if it exceeds the size of sheet then move it in to next page).

From your above example, if i change the output to EXL2K try to print on A6 paper, you can see the third section panning over page 1 and 2 (For Country ITALY - Header is one page and the rest of the section is on the other page)


Tharun Katanguru
SBOX- 8205 DEV/TEST/PROD : 8105 8205
Linux, All Outputs
June 01, 2017, 08:12 AM
MartinY
You won't be able to control the Excel page-break with Focus... especially where users can change the page format as they wish in Excel - so how could you properly manage the page break...?

Yes you can create an Excel macro that will format the page and insert Excel page-break. But for above reason will you spend time to do it ?
If you create a macro it should not manage the page-break, but the "Rows to repeat at top". That way, no matter the selected page format, the same heading will be repeated on each page.

What you can do and I suggest, is to break your data into several Excel tabs. That way you will minimize the impact of the page-break that can occurs in middle of data since each set of data has its own page set.
Then you could add the Excel macro that will manage the "Rows to repeat at top", not the page-break.
TABLE FILE CAR
PRINT CAR
BY COUNTRY
ON COUNTRY PAGE-BREAK

ON TABLE SUBHEAD
"Report Header"

HEADING
"Page Header"

FOOTING
"Page Footer"

ON TABLE SUBFOOT
"Report Footer"
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE SET COMPOUND BYTOC
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
ENDSTYLE
END

With the above sample, the "Report Heading" will appear only in first tab and the "Report Footing" in the last. So you may not want to include that.


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