Crystal Truncates Field at 160 Characters

[hubcap1324]

I have a report that is pulling from a database field that stores comments from our Manufacturing system. I can put almost 1000 characters in the field on the system side, but when running a report in Crystal it only shows me 160 characters of the field. I have played with the formatting using unlimited lines, the text box is plenty big enough. Any clues?

Using 8.5

 

[Durango122]

hi
check the text box to can grow



Durango122
Remember to used all fingers when waving to policemen

 

[hubcap1324]

Thanks. The box was already checked and was set for 0 which said it was unlimited. I changed it to like 10000 and still the same result. Anything else??

 

[BarbaraFuhrmann]

I would try to figure out wether it is the report itself or the connection to the database that cuts:

Create a formula
{@test}
Length ({TABLE_OR_VIEW.FIELD})
and display it in the report to see if the complete data is available in the report or not.

if the maximum length is 160 it could be an idea to check out the driver.

if the maximum length is > 160 but the text is not displayed, try one of the following:
- If you work on the data using the formula and have placed that formula into the report: Try what happens when you put in the database field directly.
- Use a smaller font. Does number of displayed characters increase?
- Enlarge the field in horizontal and/or upright direction. Does number of displayed characters increase?`

I think that one of this test should give you an idea what kind of problem the report has and how you can solve it.

HTH
Barbara

 

[Madawc]

Crystal 8.5 normally has a limit of 254 characters, something that higher versions overcame. So even if you get round the 160 limit (which I don't understand), you would run into the same problem.

Unless you can upgrade - which isn't cheap - your best solution is to chop up the large field into chunks that Crystal can handle.

Left({your.field}, 160)

Mid({your.field}, 161, 160)

And so on. Display may also be a problem - you can't rejoin the fragements in a formula field in 8.5 because that to would stop at 254, if not before. Putting the parts into a text box should work.


Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10