 |
|||||
|
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
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 TopicGo | Search | Notify | Tools |
| Truncation Character | Login/Join |
| Member |
We want to remove the annoying "!" character that WebFocus displays when a field is truncated. Is there any way of turning this "feature" off? Thanks. WebFOCUS version 761. Windows operating system. SQL Server database. Output: Currently creating Excel and PDF report output. | ||
|
| Virtuoso |
I don't recall ever seeing that except when I was trying to show a report in PDF that was basically a hundred character field for each line of the report. Was our way of getting output to our mainframe print server and if wanted to 'see it' would either display html or we'd use PDF. Leah | |||
|
| Expert |
Whenever I see the ! in a PDF report, I fix the report so that the field does not get truncated - therefore I find the ! character is a valuable "feature". 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 | |||
|
| Virtuoso |
I'm with Francis - fix the problem instead of the symptom. if you're using functionality like SQUEEZE= in your stylesheet that would truncate to a specific width, try using a WRAP= instead. My guess would be that that would be the only way to get rid of the ! (Short of redefining the column and shortening its length with EDIT, TRIM or something similar) 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 | |||
|
| Expert |
I, too, agree with Darin and Francis. A very useful indication that you have to do something with your report. When writing reports I always code for the three main output types of EXL2K, HTML and PDF. For PDF output all columns get subjected to specific style sheet code of - TYPE=REPORT, COLUMN=[column name], WIDTH=[width value], WRAP=[wrap value], $ and being a fussy coder I generally make sure that the columns of the report match the width of the heading and footing. T
| |||||||||
|
| Virtuoso |
Tony, WIDTH=[width value] is used only on HEADING, SUBHEAD, FOOTING or SUBFOOT. this has no affect on columns. See page 28-1117 of the WF Creating Reports Manual. WRAP=[wrap value] is used for column width contorl. Although it can also be used to affect the behavior or HEADING, SUBHEAD, etc items. Have you read my articles on HTML and PDF Report Design?   Thanks! Mickey
| |||||
|
| Virtuoso |
Mickey, I think that it would depend on the desired output. If you are using PDF, WIDTH has no effect on the width of the column but works for other components as you stated. For HTML, WIDTH does affect the column width, and functions interchangeably with WRAP. It would be easiest, however, to make your statement the "rule of thumb." 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 | |||
|
| Virtuoso |
Darin, Thanks for the information. I will need to give this a try. The WF manual seems to indicate they are each to be used for specific components of a report. Now you know why I wrote the articles. I was trying to bring some clarity to when each keyword should be used. Thanks! Mickey
| |||||
|
| Virtuoso |
Just to make this more confusing, you can use either WIDTH, WRAP or SQUEEZE interchangably to control the column width for HTML output. Go figure. Of course you must have ON TABLE SET HTMLCSS ON. Thanks! Mickey
| |||||
|
| Expert |
I'm still waiting for part III which is why I specify both in style  T
| |||||||||
|
| Virtuoso |
Tony, I haven't been inspired yet to write a PART 3. When I wrote PART 1 it was getting to be so long I had already determined to eventually write a PART 2 before PART 1 was even finished! I could probably write a PART 3 as more of a tips and techniques showing how to get around the wierd things that happen when formating for HTML or PDF. Better yet PART 3 could be about formatting for Excel! Hmmmm... Thanks! Mickey
| |||||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |