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     vertical lines between columns

Read-Only Read-Only Topic
Go
Search
Notify
Tools
vertical lines between columns
 Login/Join
 
Dharma
Silver Member
posted
Any idea how to print vertical lines between columns and horizontal lines between rows? the output format is pdf and excel. is it possible in version 5.3.3? thanks
 
Posts: 41 | Location: Boston | Registered: August 17, 2005Report This Post
Tony A
Expert
posted Hide Post
Dharma,

This was covered in a previous question with almost the same topic! Try using the search on occasion to see if your question has alread been answered.

In the topic "Vertical Lines between 2 columns" there were three different options suggested, with perhaps the most suitable solution being supplied by Susannah and involving stylesheets.
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Dharma
Silver Member
posted Hide Post
yeah, I have seen the topic "Vertical Lines between 2 columns" and solutions in it. Most of them are solutions for html output format and not for pdf or excel. Also my problem is quite complex and those solutions wont work for me. Iam using 'OVER' in my report to print columns one below the other. Now after printing for about 5 columns, they must continue from top again and these two are separated by two vertical lines. For eg:

col1 val1 | | col6 val6
col2 val2 | | col7 val7
col3 val3 | | col8 val8
col4 val4 | | col9 val9
col5 val5 | | col10 val10

i have typed '|' symbol to just indicate that its a vertical line.
can any one please help me out?
thanks
 
Posts: 41 | Location: Boston | Registered: August 17, 2005Report This Post
susannah
Expert
posted Hide Post
Dharma, if you edit your topic, the original post, to include the words "PDF" and "EXCEL" in the topic line, then experts in that area can come along and know they might be able to help.
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
reFOCUSing
Guru
posted Hide Post
Dharma,
Now that we know your report is not just a simple column report. Can you create an example of the report using the CAR table so we can see what you are trying to do.

Also do my knowledge you cannot use WebFOCUS's border function in EXCEL. So there maybe no solution for EXCEL.
 
Posts: 406 | Location: Canada | Registered: May 31, 2004Report This Post
Francis Mariani
Expert
posted Hide Post
Try this for PDF:

TYPE=DATA, COLUMN=col6 (*), BORDER-LEFT=0.01, BORDER-LEFT-COLOR=RGB(200 200 200), $
TYPE=TITLE, COLUMN=col6(*), BORDER-LEFT=0.01, BORDER-LEFT-COLOR=RGB(200 200 200), $
TYPE=DATA, COLUMN=col7 (*), BORDER-LEFT=0.01, BORDER-LEFT-COLOR=RGB(200 200 200), $
TYPE=TITLE, COLUMN=col7(*), BORDER-LEFT=0.01, BORDER-LEFT-COLOR=RGB(200 200 200), $
TYPE=DATA, COLUMN=col8 (*), BORDER-LEFT=0.01, BORDER-LEFT-COLOR=RGB(200 200 200), $
TYPE=TITLE, COLUMN=col8(*), BORDER-LEFT=0.01, BORDER-LEFT-COLOR=RGB(200 200 200), $
...

This will work for HTML only if you also code
ON TABLE SET HTMLCSS ON

Borders do not appear to work for Excel 2000
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Dharma
Silver Member
posted Hide Post
Hi, the vertical lines issue has been resolved. i have used images to display vertical lines.
thanks
 
Posts: 41 | Location: Boston | Registered: August 17, 2005Report This Post
susannah
Expert
posted Hide Post
Dharma, how did you get images to work in Excel? how did you pin them to a cell?
in my exp, they're not pinnned by default; your technique would be very useful to us all.
TIA



In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report 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     vertical lines between columns

Copyright © 1996-2020 Information Builders