crystal report multilne problem.

Question

0.00/5 (No votes)

See more:

Hi,

I want to print report like following:

108,xyz
pqr road,
xyz nagar

It is stored in sql database with CR, but when I print it in Crystal report data is (without line break)

108,xyz pqr road, xyz nagar.

How can I put line break.

In my table , i take address column with varchar(250)

any hint will be appreciated.

Hardik Shah.

Posted 19-Oct-10 4:06am

HarSha99

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kschuler · Accepted Answer · 2010-10-19T11:25:00

If the data is standard and you can always replace a space in the data with a line break, you can probably write some crystal script to do it. Try researching how to create a formula field [^]in crystal. Then using the Formula Workshop Formula editor screen, look under the String functions category for the Replace function. Your formula would be something like this:

Replace({Table.Field}, ' ', CHR(13))

I'm not sure if it's single quotes or double quotes to find the space and I'm not 100% sure the CHR(13) works for the carriage return line feed. But if you need more specifics you can probably find the correct syntax via google.