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 ENDThis 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.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
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
To close a post just please edit it and prefix its title with "[CLOSED]".