Vb Continue Lines in Next Section Crystal Report
-
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
Yeah, that is helpful. Maybe if you explained your problem a little better.sorry but it does not work.
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 + countryWHETHER 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
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
Source: https://www.vbforums.com/showthread.php?537911-new-line-in-crystal-report
0 Response to "Vb Continue Lines in Next Section Crystal Report"
Post a Comment