Print Page | Close Window

Increase the length of a string in Crystal Reports

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=15921
Printed Date: 05 May 2024 at 3:24am


Topic: Increase the length of a string in Crystal Reports
Posted By: aahmed
Subject: Increase the length of a string in Crystal Reports
Date Posted: 19 Mar 2012 at 5:59pm
Hey guys,
 
I'm having a bit of trouble with a Crystal Report.
 
There is a string in the report which is supposed to show 22 characters.
 
I have confirmed in both the database table and the stored procedure (which generates data from the aforementioned table) that the string that gets passed should show 22 characters.
 
When I execute the stored procedure in SQL Server, the string shows all 22 characters. 
 
But when I run the report in Crystal Reports, it however shows only 20.
What should I do to make the string show all of the characters?
 


-------------
Thank you.

Kind regards,
-Anas


Replies:
Posted By: FrnhtGLI
Date Posted: 20 Mar 2012 at 2:03am
Only thing I can think of is to make sure the field is large enough to display all the characters. You could try putting Can Grow on. Don't think that will do anything, but I guess it's worth a try. Also, check for any replacement formulas that may be affecting the field.

-------------
|< /\ '][' ( )

Posted By: aahmed
Date Posted: 20 Mar 2012 at 2:40pm
Hey FrnhtGLI,

Thanks for replying, but that doesn't seem to work.
I already tried "Can Grow"
I'll check the "Replacement Formulas" and let you know.


-------------
Thank you.

Kind regards,
-Anas

Posted By: aahmed
Date Posted: 21 Mar 2012 at 1:23pm
Hey guys,

Managed to figure it out.
Here's all you have to do.

Database -> Verify Database

For some odd reason, the field won't show all the characters unless it is re-sync with the database  :D


-------------
Thank you.

Kind regards,
-Anas


Print Page | Close Window