Focal Point
[CLOSED]Blank line at the top of the report

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

January 27, 2016, 03:38 PM
Jonathan K.
[CLOSED]Blank line at the top of the report
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.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs: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.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs: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.


WebFOCUS 7.6
Windows, All Outputs
January 28, 2016, 06:42 PM
Waz
That OK, thought it may help.

FYI, Documentaiton Link is here

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.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs: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