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.



Read-Only Read-Only Topic
Go
Search
Notify
Tools
Column Heading
 Login/Join
 
<Vijaya_settu>
posted
Hello Everyone ,
In my report , I want output of the column heading like this with comma 'TEST,RESULT' for the importing purpose. I know If we put comma in between, it will go to next line. Is it possible can i keep comma in the column heading like this 'TEST,RESULT' . I appreciate any thoughts or suggestion regarding this issue.
Below is my car example

TABLE FILE CAR
PRINT
CAR AS 'TEST,RESULT'
END

I want my ouput in one line with Comma:
TEST,RESULT
JAGUAR
JENSEN
DATSUN
MASERATI
TOYOTA
AUDI
TRIUMPH
ALFA ROMEO
BMW
PEUGEOT
 
Report This Post
Expert
posted Hide Post
This was a toughy. Some variation of this or a SUBHEAD?
TABLE FILE CAR
PRINT
CAR 
HEADING
"TEST,RESULT"
END


You can use POSITION to align the text.


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
<Vijaya_settu>
posted
Ginny,
Thanks for your reply, I mean to say column title by mistake in my post i said heading. I 've found this solution in focal point.

-SET &XTITLE = 'AUTO' | '&|#44;' | 'MOBILE';
DEFINE FILE CAR
AUTO,MOBILE/A20 = CAR;
END

TABLE FILE CAR
PRINT
CAR AS &XTITLE
AUTO,MOBILE
COMPUTE MOBILE,AUTO/A20 = CAR ;
BY COUNTRY
ON TABLE SET ONLINE-FMT PDF
END


Thank you
Vijaya
 
Report This Post
Virtuoso
posted Hide Post
Here's a little trick that looks kind of scary but works:

DEFINE FILE CAR
TEST,RESULT/A40=CAR;
END
TABLE FILE CAR
PRINT 
TEST,RESULT
END


If the comma is part of the field name (that's the scary part) it doesn't seem to matter. Only splits the line if it is in the AS ' ' section.


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Expert
posted Hide Post
That will only work in HTML format, not PDF. It looks like naming your column with the comma in the name is the way to go. Who knew? Smiler


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
Virtuoso
posted Hide Post
Since they were talking about importing, I was assuming that they were either doing hold format doc/wp or cutting and pasting from HTML. However, I did try it with PDF format and it seems to work OK.

In most cases I would stay completely away from using a comma in a field name (that would bomb in SQL) but since it's a define in WF, and a comma is not used as a reserved/special character, why not?


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Expert
posted Hide Post
wow that is a litte scary, as you said, Darin.. wondering how you discovered that is what makes me laugh Smiler




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
<JG>
posted
Not scary at all, It's an officially documented technique

How to have a column title display a comma?

For those of you who can not use the link

quote:

Problem:

How to have a column title display a comma? Currently the comma is causing a
separate line?


Solution:

A comma within a FIELD TITLE automatically generates a carriage return. This is
standard behavior that cannot be surpressed. In the core language, depending on
the TITLE, you could code something like the following to get around this
issue:

DEFINE FILE CAR
'INITIAL APPRAISAL AMOUNT $25,000 OR LESS'/D7=RCOST;
END
TABLE FILE CAR
SUM 'INITIAL APPRAISAL AMOUNT $25,000 OR LESS'
BY COUNTRY
END


Output generated:
 PAGE     1
 
COUNTRY     INITIAL APPRAISAL AMOUNT $25,000 OR LESS
-------     ----------------------------------------
ENGLAND                                       45,319
FRANCE                                         5,610
ITALY                                         51,065
JAPAN                                          6,478
W GERMANY                                     64,732
  


Another option is to use HEADING to display the actual FIELD TITLE and
surpress the use of the TITLE being used.

 
Report This Post
Virtuoso
posted Hide Post
Got thinking about this for some reason this morning and tried a couple other funny things. Since you can embed a comma into a report this way, I wondered what ELSE you could embed. Now I didn't get very creative, but apparently you could also embed HTML tags into the heading to get styling WITHIN the column heading - something that cannot be done with regular stylesheets. Two caveats - obviously this example only works for HTML but could possibly be adapted for other outputs, and any limitation on the length of a field name would apply to all characters used.

DEFINE FILE CAR
'THIS [b][i]Italic[/i] Title[/b]'/A30=COUNTRY;
END
TABLE FILE CAR
PRINT 
'THIS [b][i]Italic[/i] Title[/b]'
CAR
BY COUNTRY
ON TABLE SET ONLINE-FMT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='ARIAL',
     SIZE=10,
     COLOR='BLACK',
     BACKCOLOR='NONE',
     STYLE=NORMAL,
$
ENDSTYLE
END


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Expert
posted Hide Post
oh man!!!!! Cool
you are just too wicked cool.
i'm going to use that little tweakery right now.




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
<Vijaya_settu>
posted
Thank you, all of your replies. Since my report is scheduled and distribute to user from report caster with bursting,I ended up with using the following HTML Format . As Darin said, the user needs to copy and paste the output into Notepad and save it as .nab file . Then they will able uploaded their file.

-SET &XTITLE = 'AUTO' | '&|#44;' | 'MOBILE';
DEFINE FILE CAR
AUTO,MOBILE/A20 = CAR;
END

TABLE FILE CAR
PRINT
CAR AS &XTITLE
AUTO,MOBILE
COMPUTE MOBILE,AUTO/A20 = CAR ;
BY COUNTRY
ON TABLE PCHOLD FORMAT HTML
END

Thank you
Vijaya
 
Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic


Copyright © 1996-2020 Information Builders