-
Sep 1st, 2008, 03:08 AM
#1
Thread Starter
Fanatic Member
new line in crystal report
we use "vbnewline" in our vb to put one line in text.
how to put it in crystal report through coding ?
WHETHER YOU SUCCEED OR FAIL IS NOT AS IMPORTANT AS WHETHER YOU TRIED YOUR BEST
-
Sep 1st, 2008, 07:26 PM
#2
Hyperactive Member
Re: new line in crystal report
Try Chr(13) or some use Chr(13) + Chr(10)
-
Sep 2nd, 2008, 06:44 AM
#3
Thread Starter
Fanatic Member
Re: new line in crystal report
sorry but it does not work.
WHETHER YOU SUCCEED OR FAIL IS NOT AS IMPORTANT AS WHETHER YOU TRIED YOUR BEST
-
Sep 2nd, 2008, 12:04 PM
#4
Re: new line in crystal report
sorry but it does not work.
Yeah, that is helpful. Maybe if you explained your problem a little better.
Chr(13) does work but you need to set the Can Grow option of the reporting object. For example
{Customers.CompanyName} + chr(13) + {Customers.ContactTitle}
-
Sep 2nd, 2008, 04:46 PM
#5
Hyperactive Member
Re: new line in crystal report
Should've seen that myself brucevde. I have my defaults to Grow 0 automatically so I forgot about that one.
-
Sep 3rd, 2008, 12:36 AM
#6
Thread Starter
Fanatic Member
Re: new line in crystal report
i set property cangrow as true but still not working it gives space instead of new line.
WHETHER YOU SUCCEED OR FAIL IS NOT AS IMPORTANT AS WHETHER YOU TRIED YOUR BEST
-
Sep 3rd, 2008, 03:27 PM
#7
Hyperactive Member
Re: new line in crystal report
Do you want an actual line drawn on the page or do you wish to have more space available to show the text as two lines? I've never tried setting the property cangrow from code but in Crystal, it requires a numeric parameter not boolean since you can specify how many lines it will max out.
-
Sep 3rd, 2008, 11:58 PM
#8
Thread Starter
Fanatic Member
Re: new line in crystal report
i dont want to draw line.I want my text as in 2/3 lines it depends upon database structure.
For example i want to display address of customer i hv stored address in different fields in my db.
so i want to place it in this way, addr1 + newline + addr2 + addr3 + city + country
WHETHER YOU SUCCEED OR FAIL IS NOT AS IMPORTANT AS WHETHER YOU TRIED YOUR BEST
-
Sep 4th, 2008, 04:49 AM
#9
Frenzied Member
Re: new line in crystal report
try using
Code:
addr1 & chr(10) & chr(13) & addr2 & chr(10) & chr(13) & addr3 & chr(10) & chr(13) & city & chr(10) & chr(13) & country
-
Sep 8th, 2008, 05:33 AM
#10
Thread Starter
Fanatic Member
Re: new line in crystal report
WHETHER YOU SUCCEED OR FAIL IS NOT AS IMPORTANT AS WHETHER YOU TRIED YOUR BEST
-
Sep 8th, 2008, 06:28 AM
#11
Frenzied Member
Re: new line in crystal report
li'll suggestion, try the above methods in a new report (not the existing ones) and post the results. Also use a Formula Field and not the actual Fields.
Good luck
-
Jan 18th, 2013, 04:39 AM
#12
Fanatic Member
Re: new line in crystal report
Hi,
I realise that this is a very old thread but I've had a very similar problem and wanted to add my solution since one hasn't been provided yet -
If you have "Text Interpretation" set to HTML for the object as I did you must use the "<br>" to add carriage returns.
For Crystal XI -
On the report; right click the object - Format Field - Paragraph tab - Text Interpretation frame at the bottom
There is no Text Interpretation for text boxes, drag a function onto your report and size it accordingly.
Please note that there appears to be a bug if you try to add multiple breaks, the workaround is to add a white space between your breaks -
Code:
' I'm using basic syntax
Dim sOut As String
sOut=sOut & "The quick brown fox<br>"
sOut=sOut & " <br>" ' The space is important as the break is ignored otherwise!
sOut=sOut & "jumped over the lazy dog."
Formula=sOut
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|