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     Heading in to seperate cells in excel

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Heading in to seperate cells in excel
 Login/Join
 
CHERI
Gold member
posted
is it possible to have a heading in two excel cells in WebFocus release 5.23
for example, I want the heading of -
Our Claim Number: 123456

I want the text of 'Our Claim Number' to be in cell 1 and the field value of 123456 to be in cell 2.

Remember, we are using release 5.23
 
Posts: 69 | Location: OH | Registered: November 09, 2004Report This Post
FrankDutch
Virtuoso
posted Hide Post
Cheri

is it a column or report heading?




Frank
prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
Prarie
Virtuoso
posted Hide Post
If I understand what you are asking you could

DEFINE FILE WHATEVER
CLAIM/A17 = 'Our Claim Number:';
END
TABLE FILE WHATEVER
PRINT CLAIM AS ' '
VALUE AS ' '
END


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Spence
Platinum Member
posted Hide Post
try this:

TABLE FILE CAR
PRINT COUNTRY
OVER MODEL NOPRINT
ON TABLE PCHOLD FORMAT EXL2K
END


WF 8 version 8.2.04. Windows.
In focus since 1990.
 
Posts: 189 | Location: pgh pa | Registered: October 06, 2004Report This Post
mgrackin
Virtuoso
posted Hide Post
If the text is truely in a HEADING, add the following setting to your report code:

TYPE=HEADING, HEADALIGN=BODY,$

Here's an example:

TABLE FILE CAR
HEADING
"THE COUNTRY IS <COUNTRY"
PRINT RCOST DCOST
BY COUNTRY NOPRINT
BY CAR
BY MODEL
BY BODYTYPE
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
TYPE=HEADING, HEADALIGN=BODY,$
ENDSTYLE
END


Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011
 
Posts: 995 | Location: Gaithersburg, MD, USA | Registered: May 07, 2003Report This Post
Francis Mariani
Expert
posted Hide Post
I'd be surprised if EXL2K exists for version 5.2.3.


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
Doug
Expert
posted Hide Post
Perhaps you can consider the use of COLSPAN. The following is how I handled a similar situation:
TYPE=HEADING, LINE=1, COLSPAN=16, JUSTIFY=CENTER,$
TYPE=HEADING, LINE=2, COLSPAN=16, JUSTIFY=CENTER,$
TYPE=HEADING, LINE=3, ITEM=1, JUSTIFY=RIGHT, COLSPAN=6,$
TYPE=HEADING, LINE=3, ITEM=2, JUSTIFY=CENTER, COLSPAN=3,$
TYPE=HEADING, LINE=3, ITEM=3, JUSTIFY=LEFT, COLSPAN=7,$
TYPE=HEADING, LINE=4, COLSPAN=16, JUSTIFY=CENTER,$
TYPE=HEADING, LINE=5, JUSTIFY=CENTER, SIZE=9,$
TYPE=HEADING, LINE=5, ITEM=1, JUSTIFY=LEFT, COLSPAN=12,$
TYPE=HEADING, LINE=5, ITEM=2, JUSTIFY=LEFT, COLSPAN=4,$
TYPE=HEADING, LINE=6, JUSTIFY=LEFT, SIZE=9,$
TYPE=HEADING, LINE=6, ITEM=1, COLSPAN=12,$
TYPE=HEADING, LINE=6, ITEM=2, COLSPAN=4,$
-Doug




   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
ColdWhiteMilk
Platinum Member
posted Hide Post
I decided to search before posting, and once I found the right keyword (COLSPAN), I found this thread, which almost solves my problem.

The COLSPAN setting works perfectly, but I have a 5 column report, and I want the heading line that appears in two columns to appear over columns 2-5. What do I use for the HEADING values so that WebFOCUS will notice the two different ITEMS?


Production - 7.6.4
Sandbox - 7.6.4
 
Posts: 241 | Location: Bethesda, MD | Registered: August 14, 2007Report This Post
<JG>
posted
stick in spot markers <+0>
 
Report This Post
GinnyJakes
Expert
posted Hide Post
EXL2K did exist for 5.2.3.


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
ColdWhiteMilk
Platinum Member
posted Hide Post
The header line shows up in one cell as:

"1 2 3 4 5 This Should Be 6"

I've got:

TABLE FILE SF86REVIEW
HEADING
"<+0>1<+0>2<+0>3<+0>4<+0>5<+0>This Should Be 6<0>"
PRINT 
SF86REVIEW.STATUS AS 'Status'
SF86REVIEW.SCT01 AS '1'
SF86REVIEW.SCT07 AS '7'
SF86REVIEW.SCT08 AS '8'
SF86REVIEW.SCT09 AS '9'
SF86REVIEW.SCT10 AS '10'

ON TABLE SET STYLE *
ORIENTATION=LANDSCAPE,$
TYPE=TITLE, COLOR=NAVY, STYLE=BOLD+UNDERLINE, FONT=ARIAL, SIZE=10,$
TYPE=REPORT, TITLETEXT= 'RESULTS', $
TYPE=TABHEADING,STYLE=BOLD,$
TYPE=HEADING,LINE=1,ITEM=6, STYLE=BOLD,COLSPAN=2, JUSTIFY=CENTER,COLOR=AQUA,$
TYPE=SUBFOOT,STYLE=BOLD,$
TYPE=TABFOOTING,STYLE=BOLD,$
ENDSTYLE

ON TABLE PCHOLD FORMAT EXL2K
END


Production - 7.6.4
Sandbox - 7.6.4
 
Posts: 241 | Location: Bethesda, MD | Registered: August 14, 2007Report This Post
<JG>
posted
quote:
TYPE=HEADING, HEADALIGN=BODY,$


You forgot didn’t you
 
Report This Post
ColdWhiteMilk
Platinum Member
posted Hide Post
quote:
TYPE=HEADING, HEADALIGN=BODY,$


Thank you. That fixed it!


Production - 7.6.4
Sandbox - 7.6.4
 
Posts: 241 | Location: Bethesda, MD | Registered: August 14, 2007Report 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     Heading in to seperate cells in excel

Copyright © 1996-2020 Information Builders