Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Heading in to seperate cells in excel
Go
New
Search
Notify
Tools
Reply
  
Heading in to seperate cells in excel
 Login/Join
 
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, 2004Reply With QuoteReport This Post
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, 2006Reply With QuoteReport This Post
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, 2005Reply With QuoteReport This Post
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, 2004Reply With QuoteReport This Post
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, 2003Reply With QuoteReport This Post
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, 2005Reply With QuoteReport This Post
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: 3108 | Location: Tennessee, Nashville area | Registered: February 23, 2005Reply With QuoteReport This Post
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, 2007Reply With QuoteReport This Post
<JG>
posted
stick in spot markers <+0>
 
Reply With QuoteReport This Post
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, 2006Reply With QuoteReport This Post
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, 2007Reply With QuoteReport This Post
<JG>
posted
quote:
TYPE=HEADING, HEADALIGN=BODY,$


You forgot didn’t you
 
Reply With QuoteReport This Post
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, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Heading in to seperate cells in excel

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.