Varchar (20) not showing full character in crystal report

Question

0.00/5 (No votes)

See more:

Hi all,

I am using sql server 2000 and crystal report 8, i prepare one query and make report into crystal report ,one field have varchar(20) type when i run report last 4 char of this field not displaying.
please help me.

Thanks

Posted 18-Sep-13 20:18pm

mohd vaquas

Add a Solution

Comments

Salman622 19-Sep-13 2:23am

what is the length of word you have inserted in varchar(20) field

phil.o 19-Sep-13 2:48am

If you make the column a nvarchar instead of a varchar one, does it change the result?

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)

Sunil Kumar P · Answer 1 · 2013-09-18T20:42:00

Dear Developer,

You may check the database table for the data. If its size only varchar(20), you are able to save only 20 characters in the field.

The data recorded in the data table is correct, you may check the crystal reports field size for that column. You may increase the width or reduce the font size or allow text wrapping for that field to accommodate the contents in crystal reports.

you can correct your problem from these suggestions..

with regards,

Sunil