I have a report that is producing a blank line at the top of the report output. I can suppress this by using ON TABLE SET PAGE NOLEAD but then a 1 appears at the first character. If I use ON TABLE SET PAGE-NUM NOPAGE then I can suppress the 1 but a blank line appears on the first row. Is there any way I can have both the data start in the first row and remove the 1? I've tried using both but it doesn't work.
TABLE FILE CAR
PRINT
MODEL
BODYTYPE
DEALER_COST
BY MODEL SUBHEAD
"TEST"
ON TABLE SET PAGE-NUM NOPAGE
-*ON TABLE SET PAGE NOLEAD
END
This message has been edited. Last edited by: <Emily McAllister>,
WebFOCUS 7.6 Windows, All Outputs
January 27, 2016, 03:47 PM
BabakNYC
In this example the default output format is HTML. Do you have an ON TABLE PCHOLD FORMAT WP? That's the only way I see the 1 (which I think is used for printer control). Also what version of WF are you using?
WebFOCUS 8206, Unix, Windows
January 27, 2016, 03:50 PM
Jonathan K.
I am emailing the report. I've tried various .txt output formats. 7705 is what I am currently using.
WebFOCUS 7.6 Windows, All Outputs
January 27, 2016, 04:21 PM
Waz
This came in in later 7.6 version. Perhaps it may help.
SET DROPBLNKLINE=ON
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!
January 27, 2016, 04:54 PM
Jonathan K.
I've tried that too, but I think it only works with PDF outputs.
WebFOCUS 7.6 Windows, All Outputs
January 27, 2016, 05:01 PM
Waz
What version are you on ?
This, according to the documentation, came in with V7.6.11
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!
January 28, 2016, 03:33 PM
Jonathan K.
7705
WebFOCUS 7.6 Windows, All Outputs
January 28, 2016, 06:33 PM
Jonathan K.
Again, from what I've researched SET DROPBLNKLINE=ON only works for PDF's.
States : This setting does not apply to the following output formats: HOLD/PCHOLD/SAVE formats ALPHA, INTERNAL, BINARY, COM, COMT, COMMA, TAB, TABT, FIX, DFIX, all DBMS, VSAM, LOTUS, SYLK, DIF, FOCUS, and XFOCUS
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!
January 29, 2016, 03:03 AM
SSander
Check the "LINES" set if its more than 999 then it will add some blank lines.
Regards,
Release: WebFOCUS 8104, AppStudio: 8105 OS: Windows Output: HTML,Excel,Active Reports