Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Increase the length of a string in Crystal Reports Post Reply Post New Topic
Author Message
aahmed
Newbie
Newbie
Avatar

Joined: 19 Mar 2012
Location: Australia
Online Status: Offline
Posts: 3
Quote aahmed Replybullet Topic: Increase the length of a string in Crystal Reports
    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
IP IP Logged
FrnhtGLI
Senior Member
Senior Member
Avatar

Joined: 22 May 2009
Online Status: Offline
Posts: 347
Quote FrnhtGLI Replybullet 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.
|< /\ '][' ( )
IP IP Logged
aahmed
Newbie
Newbie
Avatar

Joined: 19 Mar 2012
Location: Australia
Online Status: Offline
Posts: 3
Quote aahmed Replybullet 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
IP IP Logged
aahmed
Newbie
Newbie
Avatar

Joined: 19 Mar 2012
Location: Australia
Online Status: Offline
Posts: 3
Quote aahmed Replybullet 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
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.