 |
|||||
|
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 |
| Wrapping line on a delimiter | Login/Join |
| Member |
I have a field with Member Names formatted as LastName, Firstname I want the report to WRAP on the comma. For example Smith, Joe should print like this: Member Name Smith, Joe Watts, Michael Goralczyk, Elizabeth WRAP does not help much with this requirement. 8.0.03/Windows7 | ||
|
| Expert |
If it's for HTML only, you can use the string substitution function to replace the comma by a line break (, ). This *might* work for Excel. I don't think there's any way to do it for PDF. 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 | |||
|
| Expert |
I think the only way to do this for all outputs is to convert the blocks delimited by the comma to rows. Perhaps Macgyver method will work, not knowing the structure of the report. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Member |
The output format is PDF. There are several columns in the report that need to be on multiple lines. Some will use commas as the delimiter and others will use spaces. The Crystal report sample does it very nicely - I was hoping I could duplicate what they did in Crystal. 8.0.03/Windows7 | |||
|
| Expert |
How does the Crystal Reports program do it? 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 | |||
|
| Master |
Yes, WebFOCUS supports line breaks within PDF report columns.  -* File PDFSkipLine.fex
APP PREPENDPATH IBISAMP
-*
DEFINE FILE GGSALES
-* Create data to match requirements.
MEMBERNAME/A40 = DECODE SEQ_NO (1 'Briars, David'
2 'Watts, Michael');
-* Convert comma delimiter to carriage return.
MNAME_OUT/A40 = CTRAN(40, MEMBERNAME, 044, 013 , 'A40');
END
-*
TABLE FILE GGSALES
PRINT SEQ_NO
MEMBERNAME
MNAME_OUT AS 'Member, Name'
REGION
IF RECORDLIMIT LE 2
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=REPORT, FONT=ARIAL, SIZE=10, SQUEEZE=ON,$
TYPE=REPORT,LINEBREAK='CR',$
ENDSTYLE
END
| ||||
|
| Expert |
Best answer David! 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 | |||
|
| Expert |
Nice,  Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Member |
David, thank you - that is EXACTLY what I am looking for. U da man!!!! Thank you sooo much. 8.0.03/Windows7 | |||
|
| 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 |