Help! Text in Detail section in CR8 is being cut off.

[cheerfulskeptic]

Hello,
I have a subreport that contains a simple detail section t hat shows a comments field from an SQL Server db of type text. The subreport is linked to the main report with just 1 parameter. The text field is geting cut off at around 190 characters. However, if I create a standalone report with just that particular field and no subreport, or when i print out the contents of that field in an ASP page I get the complete field, without any cut out text. What seems to be the problem?
Thanks!

 

[lbass]

Do you have "can grow" checked for the field within the subreport as well as for the subreport itself (format->subreport->common->can grow)?

-LB

 

[synapsevampire]

As LB suggests, you'd need the can grow turned on, but since you have 190 characters, I'd guess that you may have a bigger problem.

CR 8 does not allow fields > 254 chars to be used in a formula, but if you just drop the field into the report it should display the contents beyond 254.

You might try using a SL Expression and casting the text to another data type, such as a varchar():

cast(table.field as varchar(1000))

Perhaps that will then display in it's entirety.

-k

 

[cheerfulskeptic]

yes, they are both checked.. with 0 lines for unlimited.

 

[cheerfulskeptic]

nope, the cast did not work. I even changed the field to datatype of varchar (4000), since a max chars of 4000 can be entered via the web interface...

 

[synapsevampire]

Very odd...

Try a SQL Expression containing:

substring(table.field,1,254)

Do you get 254 characters?

Since this SQL Expression field can be used within a frmula, you can now use it to test for unusual contents.

Are you using ODBC?

-k