line break in a formula field
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=5383
Printed Date: 29 Apr 2024 at 11:29am
Topic: line break in a formula field
Posted By: maryammarz
Subject: line break in a formula field
Date Posted: 30 Jan 2009 at 11:17pm
|
hi all!
I have a formula field and it Concatenates strings. I want each string be in a new line.
any help would be appreciated.
Maryam
|
Replies:
Posted By: ezeney
Date Posted: 01 Feb 2009 at 9:25am
|
I would use ChrW() to insert ASCII characters. The following code will print each word on a new line:
"What" + ChrW(13) + "is" + ChrW(13) + "CR?"
You need to make sure that your object 'Can Grow' option is checked.
|
Posted By: maryammarz
Date Posted: 03 Feb 2009 at 10:00pm
| thanx a lot, it works. |
Posted By: UdeIni
Date Posted: 08 Dec 2009 at 9:45pm
It works !!!!!!! Thanks a lot for the help 
|
Posted By: Lennie
Date Posted: 19 Mar 2010 at 10:55pm
|
Hi Maryammarz and UdeIni,
I am having the same problem with LINE FEED on crystal report as I am new to Crystal Report. Instead of having the Crystal Report data source attached to DataSet or Table, Being instructed to use 4 TEXT OBJECTs within a row and fill it with data.
Here is an example of the expected report :
11024 13/09/1990 $75.25 Sir Rodney's Scones
11024 25/09/1990 $5.75 Vegie-spread
but it display only the last row
11024 25/09/1990 $5.75 Vegie-spread
Please share with me your coding that perform LINE FEED
Thank You,
Cheeres,
Lennie
------------- Have a Good Day, Cheers, Lennie |
Posted By: Victoryy
Date Posted: 13 Jan 2011 at 11:49pm
| Thanks a lot. It helped me...... |
Posted By: Apex
Date Posted: 23 Aug 2011 at 7:39am
|
Hi,
Can you share your code on how you only select to display the latest line item?
Thanks, Winnie |
Posted By: comatt1
Date Posted: 23 Aug 2011 at 8:26am
|
there is a nextisnull function you can use...
so suprress details until this is true nextisnull(value) been a while, I could be wrong |
Posted By: achandana01
Date Posted: 10 Mar 2014 at 10:49am
|
Hi I used this function and it worked for me perfectly however my question is when I export it into excel data is not restricted only to single line . For instance take the phrase "what is CR" and I have another row "Crystal reports". here is how I get when i export into excel
Excel Line data
1 what
is
CR
4 crystal reports
is there a way how to do it without overlapping rows ?
------------- chand |