Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] eliminating blank line between report heading and data

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] eliminating blank line between report heading and data
 Login/Join
 
<kj>
posted
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,
 
Report This Post
Expert
posted Hide Post
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.
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Gold member
posted Hide Post
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.
 
Posts: 71 | Registered: November 20, 2003Report This Post
<Pietro De Santis>
posted
The "space" is not a blank line but space left over from the underline.

 
Report This Post
<kj>
posted
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
 
Report This Post
<kj>
posted
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
 
Report This Post
Member
posted Hide Post
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
 
Posts: 14 | Location: Seattle, WA | Registered: June 15, 2005Report This Post
Guru
posted Hide Post
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 "
 
Posts: 346 | Location: Melbourne Australia | Registered: April 15, 2003Report This Post
Member
posted Hide Post
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.
 
Posts: 14 | Location: Seattle, WA | Registered: June 15, 2005Report This Post
Silver Member
posted Hide Post
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
 
Posts: 33 | Location: New York, USA | Registered: August 11, 2003Report This Post
Expert
posted Hide Post
That's genius!
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Member
posted Hide Post
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 Smiler I'm very new to webfocus, we are converting from Business Objects to WF 769.


WebFOCUS 767, Windows XP
Excel, HTML, PDF
 
Posts: 15 | Registered: March 11, 2009Report This Post
Expert
posted Hide Post
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?


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Member
posted Hide Post
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,


WebFOCUS 767, Windows XP
Excel, HTML, PDF
 
Posts: 15 | Registered: March 11, 2009Report This Post
Expert
posted Hide Post
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.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Expert
posted Hide Post
By the way, I use Tiny Pic to upload screenshots and then use the URL they provide to embed it in a FocalPoint posting.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Member
posted Hide Post
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,


WebFOCUS 767, Windows XP
Excel, HTML, PDF
 
Posts: 15 | Registered: March 11, 2009Report This Post
Expert
posted Hide Post
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.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Expert
posted Hide Post
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


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Virtuoso
posted Hide Post
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!

Mickey

FOCUS/WebFOCUS 1990 - 2011
 
Posts: 995 | Location: Gaithersburg, MD, USA | Registered: May 07, 2003Report This Post
Member
posted Hide Post
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,


WebFOCUS 767, Windows XP
Excel, HTML, PDF
 
Posts: 15 | Registered: March 11, 2009Report This Post
Expert
posted Hide Post
Mickey to the rescue! You're definitely the PDF Guru I was thinking about Smiler


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Expert
posted Hide Post
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




   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Member
posted Hide Post
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



 
Posts: 23 | Location: Cincinnati, OH | Registered: September 25, 2013Report This Post
Expert
posted Hide Post
You can always extend your CSS to control that -

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


T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] eliminating blank line between report heading and data

Copyright © 1996-2020 Information Builders