Is there a way to getrid of blank line displays between report heading and report data?

thanks,
kj

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

kj, if you mean the 2 blank lines between the top of the html table and the beginning of the table (above the HEADING actually), this command
ON TABLE SET PAGE NOLEAD
just before your style sheet works, most of the time; its squirrelly, tho.

HI Susannah!!
If I am right, KJ is not asking how to remove the blank lines above the heading.
KJ is asking how to remove the blank lines between the Column TITLE and the first line of Data display.Am I right KJ?
For an example following code generates the report
-MRNOEDIT BEGIN
-SET &ECHO=ALL;
TABLE FILE CAR
PRINT
*
HEADING CENTER
"CAR REPORT"
ON TABLE SET ONLINE-FMT PDF
-*ON TABLE SET PAGE NOLEAD
END
-MRNOEDIT END

as follows
CAR REPORT
COUNTRY CAR MODEL
------- --- -----
---here is the blank line---
ENGLAND AAUDI abccc


Tried with ON TABLE SET PAGE NOLEAD, but it deletes the lines above the heading CAR REPORT including line contains the page number too.
It would be of great help if I can get a code which deletes the blank line after the TITLE.

The "space" is not a blank line but space left over from the underline.

Krishnan you are right. I am trying to get rid of the blank lline between heading and first line of data. In HTML we could do it with CSS. But am looking for a solution for PDF.

Thanks,
kj

Krishnan you are right. I am trying to get rid of the blank lline between heading and first line of data. In HTML we could do it with CSS. But am looking for a solution for PDF.

Thanks,
kj

Did you ever find a solution to your problem? I have the same issue right now with wanting to get rid of the blank line between the header and the column titles in PDF.

Marie

I tried removing the line under the column titles and a blank line remains. The only way I found to remove the blank line is to turn off the column-titles and put them in the Page Heading...

CAR AS ''
BY COUNTRY AS ''

HEADING
"CAR REPORT"
" "
"COUNTRY <+0 CAR "

Thanks! However, as far as I could tell, that only moved the "problem" blank line from between the header and the column titles to be between the column titles and the data.

Maybe you can try something like this

TABLE FILE CAR
PRINT
COUNTRY CAR MODEL BODYTYPE SEATS
HEADING CENTER
"CAR REPORT"
ON TABLE SET ONLINE-FMT PDF
ON TABLE SET STYLE *
TYPE=TITLE, BORDER=LIGHT,BORDER-COLOR=WHITE,$
END

M

That's genius!

quote:

Thanks! However, as far as I could tell, that only moved the "problem" blank line from between the header and the column titles to be between the column titles and the data.

Hello all, I am having the same issue- blank line between column titles and data. I also tried -

quote:

TYPE=TITLE, BORDER=LIGHT,BORDER-COLOR=WHITE,$

but it doesn't get rid of the line.
is there another way to do this?
Appreciate all help!
PS I'm very new to webfocus, we are converting from Business Objects to WF 769.

TABLE FILE CAR
PRINT
COUNTRY CAR MODEL BODYTYPE SEATS
HEADING CENTER
"CAR REPORT"
ON TABLE SET ONLINE-FMT PDF
ON TABLE SET PAGE NOLEAD
ON TABLE SET STYLE *
END

Generates this:

TABLE FILE CAR
PRINT
COUNTRY CAR MODEL BODYTYPE SEATS
HEADING CENTER
"CAR REPORT"
ON TABLE SET ONLINE-FMT PDF
ON TABLE SET PAGE NOLEAD
ON TABLE SET STYLE *
TYPE=TITLE, BORDER=LIGHT,BORDER-COLOR=WHITE,$
END

Generates this:


What gap would you like to suppress?

I tried to attach/copy paste a screenshot of my report, but couldn't figure out yet how.
here is what I did in my report -
I moved the column titles to the heading. so this gets rid of space between heading and column titles. but there is still space between the titles and data, which is what I want to remove. Francis, the 2nd screenshot you posted does not have a blank line between titles and data. that is the look I want.

When I applied borders to Heading and data to create Box around the full report,this space/blank line does not show left and right borders.
My real goal is to get the right and left borders to be continuous across heading and data, creating a 'box' like look.
I am thinking - either remove the blank line OR get the left and right borders to show on the blank line.

here is my code:

 TABLE FILE HOLDTBL1
PRINT
     'HOLDTBL1.HOLDTBL1.Column1' AS ''
     'HOLDTBL1.HOLDTBL1.Column2' AS ''
     'HOLDTBL1.HOLDTBL1.Column3' AS ''
     'HOLDTBL1.HOLDTBL1.Column4' AS ''
BY 'HOLDTBL1.HOLDTBL1.DISPLAY_DT' NOPRINT
BY 'HOLDTBL1.HOLDTBL1.SORT_ORDER_NB' NOPRINT
HEADING
"Headertine1"
" "
"Headerline3"
" "
"Column1 <+>Column2 <+0>Column3 <+0>Column4"
ON TABLE SET PAGE NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
$
     UNITS=IN,ORIENTATION=PORTRAIT,$
     TYPE=HEADING,LINE=5,SIZE=8,OBJECT=TEXT,ITEM=1,POSITION='N3',$
     TYPE=HEADING,LINE=5,SIZE=8,OBJECT=TEXT,ITEM=2,POSITION='N4',$
     TYPE=HEADING,LINE=5,SIZE=8,OBJECT=TEXT,ITEM=3,POSITION='N5',$
     TYPE=HEADING,LINE=5,SIZE=8,OBJECT=TEXT,ITEM=4,POSITION='N6',$

TYPE=TITLE,COLUMN=N3,BORDER-LEFT=LIGHT,$
TYPE=TITLE,COLUMN=N5,BORDER=LIGHT,BORDER-COLOR=WHITE,$
TYPE=TITLE,COLUMN=N6,BORDER-RIGHT=LIGHT,$
TYPE=TITLE, BORDER=LIGHT,BORDER-COLOR=WHITE,$
TYPE=DATA,COLUMN=N3,BORDER-LEFT=LIGHT,JUSTIFY=LEFT,$
TYPE=DATA,COLUMN=N6,BORDER-RIGHT=LIGHT,JUSTIFY=RIGHT,$
TYPE=HEADING,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=OFF,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
$
ENDSTYLE
END 

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

You're using the HEADING to set up your column titles, but then styling the column titles with TITLE.

May I suggest that you create a demo fex that anyone can run, using the CAR file for instance. Here's something to start with:

TABLE FILE CAR
PRINT
COUNTRY AS 'Column1'
CAR AS 'Column2'
MODEL AS 'Column3'
SALES AS 'Column4'
BY COUNTRY NOPRINT
BY CAR NOPRINT

HEADING
"Headerline1"
" "
"Headerline3"
" "
ON TABLE SET PAGE NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF

ON TABLE SET STYLE *
UNITS=IN,ORIENTATION=PORTRAIT,$
TYPE=HEADING, BORDER=LIGHT, $

TYPE=TITLE, BORDER=LIGHT,$
ENDSTYLE
END

I don't think the gap between the HEADING and column TITLE can be eliminated.

By the way, I use Tiny Pic to upload screenshots and then use the URL they provide to embed it in a FocalPoint posting.

Thanks for the info on Tiny Pic! I don't see the CAR file as one of our master files..it probably didn't come with the install.
I'll try to get the image of my report up here.


..and it worked!
I want to not have a gap in the left and right borders like this picture shows.

I also removed the 'title' styling and still get the above result.
thanks for your help!

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

I changed Francis' title stying to match Mickey's

TYPE=TITLE, BORDER=LIGHT,BORDER-COLOR=WHITE,$

and it removed the space between the column titles and the data.

The CAR master is in directory ibisamp and comes with the software but you may not have that directory in the global path.

The CAR FOCUS database and Master is probably in the ibisamp folder.

A PDF guru will have to step in - I'm not sure if this gap can be eliminated.

By the way, Tiny Pic nicely provides the complete code to place an image in a FocalPoint posting, so you don't need to use additional [IMG] tags

As you requested Francis. PDF Guru to the rescue! (Sorry I couldn't resist)

Once you turn on the GRID or use a BORDER a blank line will always appear between the HEADING and the TITLEs/DATA. There is no way to make it go away once you turn on either of these features. This is one of my pet peeves with GRIDs and BORDERs because it deviates from the age old rule of FOCUS language behavior in which a blank line was NEVER put between the HEADING and the TITLEs unless coded into the HEADING.

Try using the SUBHEAD as in the following example.

TABLE FILE CAR
PRINT RCOST AS ''
BY COUNTRY AS ''
BY CAR AS ''
BY MODEL AS ''
BY BODYTYPE AS ''
ON COUNTRY SUBHEAD
"This is the HEADING text"
" "
"Country<+0>Car<+0>Model<+0>Body<+0>RCOST"
ON COUNTRY SUBFOOT
" "
ON TABLE SET PAGE NOLEAD
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=REPORT, SQUEEZE=ON, GRID=OFF, FONT='ARIAL',$
TYPE=SUBHEAD, BORDER-TOP=MEDIUM, BORDER-LEFT=MEDIUM, BORDER-RIGHT=MEDIUM, STYLE=BOLD,$
TYPE=SUBHEAD, LINE=3, OBJECT=TEXT, ITEM=1, POSITION=0.00,$
TYPE=SUBHEAD, LINE=3, OBJECT=TEXT, ITEM=2, POSITION=P2,$
TYPE=SUBHEAD, LINE=3, OBJECT=TEXT, ITEM=3, POSITION=P3,$
TYPE=SUBHEAD, LINE=3, OBJECT=TEXT, ITEM=4, POSITION=P4,$
TYPE=SUBHEAD, LINE=3, OBJECT=TEXT, ITEM=5, POSITION=P5, JUSTIFY=RIGHT,$
TYPE=SUBFOOT, BORDER-TOP=MEDIUM,$
TYPE=DATA, COLUMN=P1, BORDER-LEFT =MEDIUM,$
TYPE=DATA, COLUMN=P5, BORDER-RIGHT=MEDIUM,$
ENDSTYLE
END

Thanks everyone for your input.
I tried Mickey's solution and got it working. Here's my output-


I added a blank line in the subhead after the column names line, 'cause that was requested. but I can get the left & right borders on the space!
Thank you!

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

Mickey to the rescue! You're definitely the PDF Guru I was thinking about

Let's revisit this. Consider the following code and remove the blank line between the HEADING and column TITLEs while using BORDERs as seen in Report 2.

SET PAGE NOLEAD
TABLE FILE CAR
HEADING
"Report 1: This is the HEADING text"
PRINT RCOST BY COUNTRY BY CAR BY MODEL BY BODYTYPE WHERE COUNTRY LE 'ITALY'
ON TABLE SET PAGE NOLEAD
-*ON TABLE SET HTMLCSS ON
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET STYLE *
TYPE=REPORT, SQUEEZE=ON, GRID=OFF, BORDER=LIGHT, FONT='ARIAL',$
ENDSTYLE
END
-RUN
TABLE FILE CAR
HEADING
"Report 2: This is the HEADING text"
PRINT RCOST BY COUNTRY BY CAR BY MODEL BY BODYTYPE WHERE COUNTRY LE 'ITALY'
ON TABLE SET PAGE NOLEAD
ON TABLE SET HTMLCSS ON
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET STYLE *
TYPE=REPORT, SQUEEZE=ON, GRID=OFF, BORDER=LIGHT, FONT='ARIAL',$
ENDSTYLE
END
-RUN

Adding the following to the end of the procedure removes the blank line. Unfortunately, it also removes the bottom line of the table.

  
-HTMLFORM BEGIN
<STYLE>
.x4 {display: none};
</STYLE>
-HTMLFORM END

You can always extend your CSS to control that -

-HTMLFORM BEGIN
<STYLE>
.x4:first-of-type {display: none};
</STYLE>
-HTMLFORM END

T