Focal Point
[SOLVED] Too much white space at report bottom

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

December 03, 2013, 05:07 PM
RobertF
[SOLVED] Too much white space at report bottom
I have thrown every command I can think of at this. Nevertheless I end up with about 3" of whitespace following my footer. I color coded the sections and it appears this whitespace is not recognized as footer or data space. Code is below...ideas?

SET ALL=PASS
DEFINE FILE ANALYZER_INVOICE_VW
LocationGrp/A10=IF ANALYZER_INVOICE_VW.INVOICE.Location_Number EQ '11' THEN 'OFFICE' ELSE 'OTHER';
END
TABLE FILE ANALYZER_INVOICE_VW
SUM
ANALYZER_INVOICE_VW.CPTCODES.UNITS AS 'Units'
ANALYZER_INVOICE_VW.CPTCODES.wRVUs
BY ANALYZER_INVOICE_VW.PROVIDERS.BillingProviderSUI NOPRINT
BY HIGHEST LocationGrp NOPRINT
BY LOWEST ANALYZER_INVOICE_VW.PATIENT.PAT_NM AS 'Patient Name'
BY LOWEST ANALYZER_INVOICE_VW.INVOICE.Billing_Area_ReportingNum AS 'CC'
BY LOWEST ANALYZER_INVOICE_VW.DATES_INVOICE_LEVEL.Date_Of_Service AS 'DOS'
BY LOWEST ANALYZER_INVOICE_VW.PROVIDERS.RendProviderName AS ' Rend Prov Nm'
BY LOWEST ANALYZER_INVOICE_VW.CPTCODES.Procedure_Code AS 'Cpt'
BY LOWEST ANALYZER_INVOICE_VW.CPTCODES.Procedure_Name AS 'CptName'
BY LOWEST ANALYZER_INVOICE_VW.CPTCODES.Current_RVU99 AS 'Current,wRVu'

ON LocationGrp SUBTOTAL AS '*TOTAL'
HEADING
"PATIENT WRVU DETAIL REPORT"
"" FOOTING
"LVPG CONFIDENTIAL INFORMATION"
WHERE ANALYZER_INVOICE_VW.CPTCODES.Procedure_Code NE '""';
WHERE ANALYZER_INVOICE_VW.INVOICE.Group_Number NE '20' OR '100';
WHERE ANALYZER_INVOICE_VW.PROVIDERS.BillingProviderReportingName EQ &BillProvNm.(OR(FIND TBLMSTR_PROVNBRNPIRPTNAMEXREF.TBLMSTR_PROVNBRNPIRPTNAMEXREF.RPTPROVNAME,TBLMSTR_PROVNBRNPIRPTNAMEXREF.TBLMSTR_PROVNBRNPIRPTNAMEXREF.RPTPROVNAME IN tblmstr_provnbrnpirptnamexref)).Select Billing Proivder/s.;
WHERE ANALYZER_INVOICE_VW.DATES_INVOICE_LEVEL.Inv_Cre_Period_Rolling_Months EQ -1;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET LINES 999999
ON TABLE SET BYDISPLAY ON
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
TYPE=REPORT,GRID=OFF,
ORIENTATION=LANDSCAPE,
PAGESIZE=Letter,
TOPMARGIN=0.25,
BOTTOMMARGIN=0.25,
LEFTMARGIN=0.25,
RIGHTMARGIN=0.25,
$
TYPE=REPORT,
FONT='ARIAL',
SIZE=8,
COLOR=RGB(66 70 73),
STYLE=NORMAL,
LINES-PER-PAGE=20,
$
TYPE=DATA,
FONT='ARIAL',
SIZE=8,
$
TYPE=DATA,
COLUMN=N3,
FONT='ARIAL',
SIZE=8,
$
TYPE=DATA,
COLUMN=N6,
FONT='ARIAL',
SIZE=8,
$
TYPE=DATA,
COLUMN=N2,
FONT='ARIAL',
SIZE=8,
$
TYPE=DATA,
COLUMN=N8,
FONT='ARIAL',
SIZE=8,
$
TYPE=DATA,
COLUMN=ROWTOTAL(*),
FONT='ARIAL',
SIZE=8,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=2,
BACKCOLOR=RGB(205 205 205),
$
TYPE=HEADING,
LINE=2,
OBJECT=TEXT,
ITEM=2,
BACKCOLOR='WHITE',
$
TYPE=HEADING,
LINE=2,
OBJECT=FIELD,
ITEM=1,
BACKCOLOR='WHITE',
$
TYPE=HEADING,
LINE=3,
OBJECT=FIELD,
ITEM=1,
BACKCOLOR='WHITE',
$
TYPE=FOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
SIZE=8,
$
TYPE=REPORT,
COLUMN=N3,
FONT='ARIAL',
SIZE=8,
COLOR=RGB(66 70 73),
STYLE=NORMAL,
$
TYPE=REPORT,
COLUMN=N6,
FONT='ARIAL',
SIZE=8,
COLOR=RGB(66 70 73),
STYLE=NORMAL,
SQUEEZE=1.527778,
$
TYPE=REPORT,
COLUMN=N8,
FONT='ARIAL',
SIZE=8,
COLOR=RGB(66 70 73),
STYLE=NORMAL,
SQUEEZE=2.597222,
$
TYPE=REPORT,
COLUMN=ROWTOTAL(*),
FONT='ARIAL',
SIZE=8,
COLOR=RGB(66 70 73),
STYLE=NORMAL,
$
ENDSTYLE
END

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


WebFOCUS 8206.08
Windows, All Outputs
December 03, 2013, 05:16 PM
Waz
Please post your code between the code tags.

I can't see your footer.

Did you try FOOTING BOTTOM ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

December 04, 2013, 08:22 AM
Jim Conrad
I have the same issue. It only appears to happen when creating PDF output. And yes, I have FOOTING BOTTOM in the FOCUS code.

Searching online, I see others reporting the same issue (in 2004 and 2006!) with no solution.


WebFOCUS 7.6.11
Windows, All Outputs
December 04, 2013, 08:51 AM
RobertF
CLOSE------------------
A google of FOOTING BOTTOM lead me to a post with:

SET PRINTPLUS=ON

THIS DID THE TRICK...no idea why...but it's working now!


WebFOCUS 8206.08
Windows, All Outputs
December 04, 2013, 12:59 PM
njsden
quote:
SET PRINTPLUS=ON


That is one of my default settings. Can't get any "decent" output without it Smiler

To close a post just please edit it and prefix its title with "[CLOSED]".



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.