How to Split a database field's length into a specific width

Question

0.00/5 (No votes)

See more:

i want to split the databse field which is getting displayed on crystal report
means a field on crystal report
like-"xxxxxxxxxx xxxxxxxxxxxxxxxx xxxxxxxxxxxxx xxxxxx"
but i wish to print like
"xxxxxxxxxx xxxxxxxxxxxxxxxx
xxxxxxxxxxxxx xxxxxx"

my question is that,when we are dragging database field name on crystal report,which is showing the value on crystal report which is represented by that field in database,that value i want to spit
e.g a address field which can have a large value in side database and when i will drag that address field on crystal report that gone a show that entire address value in a single line like

address
----------------------------------------------
xxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxx,xxxxxxxxxxxx
----------------------------------------------
but wish to split that address into more than one line accoerding to the specific length it means i wish to display that address like

address
-----------------------------------------
xxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxx,xxxxxxxxxxxx
-----------------------------------------
is it possible in crystal reports??
if yes,then how??
this is my question,
Thanks in advance

Posted 15-Jan-16 0:57am

Madhav Gunjal

Updated 15-Jan-16 16:43pm

v4

Add a Solution

Comments

deepankarbhatnagar 15-Jan-16 7:03am

Not getting your point..

4 solutions

Solution 3

If I understand the question correctly, you'll need to define wrapping for the field in the report. Have a look at these instructions: Wraping field in crystal report | Sochinda's Blog[^]

Posted 15-Jan-16 6:40am

Wendelius

Solution 1

This seems like a text justification problem, check link which should help you in resolving the solution

How to align a text to justified in crystal reports? - Stack Overflow[^]

Posted 15-Jan-16 1:41am

_Asif_

Solution 2

You'll want to split it in your query so that you have two fields. Then just place the fields however you want on the report.

Posted 15-Jan-16 1:46am

ZurdoDev

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)

Member 11449483 · Accepted Answer · 2016-01-15T23:53:00

Solution 4

use css property for split text according to column max-width.

word-break: break-all;
word-wrap: break-word;
max-width: 155px;

Posted 15-Jan-16 23:53pm

Member 11449483