CODEWITHSUNDEEP
crystal-reports
Alicia Uhacz
Alicia Uhacz

Reputation: 77

How do you either remove or set the character limit of a field in Crystal Reports?

We have a field that has a character limit set to 20, but I can't figure out how to remove it or set it to something higher.

Upvotes: 0

Views: 5779

Answers (3)

user13263918
user13263918

Reputation: 11

You can use the left formula in string function in crystal reports and limit the field value to certain characters. 

Left({TableName},25)

will show the first 25 characters.

Either goes for right formula as well.

Upvotes: 1

Siva
Siva

Reputation: 9101

If it is in crystal report there is no limitation on number of characters you can just expand the field. If it is in database nothing can be done at crystal report. You need to change at database level.

Upvotes: 0

Lan
Lan

Reputation: 1346

This will be retrieved from then database. Why do you want to change it ? If you changed the size of the field in the database and you want to update it inside the report use "Verify database".

Upvotes: 1

Related Questions