Field text is being truncated inconsistently

Calypso picture Calypso · Jan 26, 2011 · Viewed 11.1k times · Source

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

Answer

user5063113 picture user5063113 · Jun 29, 2015

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