TEXT FIELD LENGTH

[Lambro]

I'm using a text field on my report in the details section that uses information from a data field. The text field seems to be limiting me to 50 characters only. I need to put more then that in the text field. I turned on the "grow" option. Please help. I'm using Crystal Reports 8.5 Developers Edition

 

[synapsevampire]

There isn't a 50 character limit.

Drop one in alongside and instead of using a field in it, type a 100 characters, you'll see that there's no limit like that.

Are you dropping a table field or a formula field into the text box? If it's a formula, I'd guess that your formula is at fault, otherwise, right click any table field and select browse data to learn it's length.

-k

 

[Lambro]

when I right click it says Field Type: String and Length: 50 on all 3 of my fields. They are pulled from an SQL database and each one has a different length in the SQL database.

 

[synapsevampire]

Hmmm, what are the data types with SQL Server, and what version of SQL Server?

Are you using a View or a SQL Expression in which it might be CAST as another data type?

-k

 

[Lambro]

I'm using a view

 

[synapsevampire]

I'd guess that the View is Casting or altering the data.

Open the View up and see what it's doing.

-k

 

[Lambro]

I looked at the view in the Enterprise Manager and all my data apears fine. The lengths are not cut short.

 

[synapsevampire]

OK, what are the data types in the view?

-k

 

[Lambro]

how can you see the data types of a view?

 

[lyanch]

Try verifying the database.. (database->verify). Sometimes crystal gets confused when things change and doesn't give proper string length. Usually a verify will fix it up.

Lisa

 

[synapsevampire]

Can you look at the SQL in the View?

If it doesn't use any functions in there, then just verify that it's pulling from the table columns you expect, and that they are the type and size you expect.

-k