CODEWITHSUNDEEP
crystal-reportscrystal-reports-xi
Calypso
Calypso

Reputation: 31

Field text is being truncated inconsistently

I created a label report (2 columns). The fields used are, Suffix, Contact Name, Company Name, Job Title and Department – simple contact data.

The Department field is the last one and in the report of 78 records the Department field decided not to display the entire field text twice.

I have "Can Grow" set as default on all fields, I checked the margins and label width to ensure the text is not being truncated because of the labels being too wide for the margins. I modified the data in the database by abbreviating certain words and it shows the change but it still truncates after 50 characters. Other times the Department name is 80+ characters and it displays all of the data.

This problem is happening onscreen when I preview the report and also when various users print it. The default printers have not changed.

This one has me stumped. Is this an application bug (if so is there a Service Pack for CR 11.5?) or does it have anything to do with printer drivers in need of update?

Thanks in advance for your help on this puzzle.

Update

  1. I did specify data source
  2. The text in the database is without any special characters or anythig else that might be out of place
  3. No I am not using Underlaying Following sections anywhere in the document
  4. 11.5.8.998 is my version of CR (lloks like I am behind - however, when I click on verify for updates it tells me there aren't any. Do you ahve a link to the SP2 download?)
  5. No formula in the Custom string option

Upvotes: 3

Views: 12842

Answers (3)

user5063113
user5063113

Reputation: 51

Mine worked by simply going to the Database Menu option: Database-->Verify Database, and the field sizes were updated

Upvotes: 5

Atbin
Atbin

Reputation: 21

It could happen if the length of the field in the Data Source is less than your string. To check this:

  1. In the Field Explorer right click on the data source name and choose "Show Field Type"

  2. The length of the field is written between ( ). If it is less than your string length, you have to re-build your data source. For example, if your data source is a view, you have to drop and create it again and then verify your data base in crystal report.

Hope it helps.

Upvotes: 2

PowerUser
PowerUser

Reputation: 11791

Random troubleshooting thoughts. One of these could even work :)

  1. You didn't specify your datasource, but can you preview your data before it goes into Crystal? If the actual data is randomly truncated, then the problem isn't Crystal, it's the data.

  2. Does this data have any special characters, i.e. accents, foreign currencies, etc? That could be a problem (I don't know if this could even create problems, never used them in Crystal)

  3. In the Section Expert, are you using the Underlaying Following Sections option for fancy formatting? If so, your 'grown' fields may be hidden by some other field in the following section.

  4. My Crystal Reports XI Developer Edition is 11.5.12.1838 (that's service pack 2). Is your Crystal up to date?

  5. In the Format Field pane, there is an option to make a custom Display String. Sometimes I forget I have a formula and then don't understand why it's not doing what i want.

Upvotes: 0

Related Questions