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.
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
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, 2007
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, 2007
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.
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, 2007
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