Large Size of fieldname causing error in report

[akohli]

Hi,

Was unsuccesful finding anything on this in a cursory search, so here goes. My main report is a container for eleven sub-reports. The only thing that causes it to error out is when i place a field on it the name of which is 32 characters long.(Could this be a factor?) This field is not grouped on, just displayed as a column.

when i delete this field from the report, the report runs fine. just in case this is relevant, i also noticed that in the field dialog box/window, this field name is truncated. i cud just change the sproc that this report calls, but then the schema would change and i'd have to rebuild the whole report, so hoping to avoid that unless I abs. cannot.

Thanks.

Amit

 

[Turkbear]

Hi,
Try creating a formula that , in essence, aliases that field name, Use the formula in place of the actual field..see if that helps..

@shortername
{longfieldnameishere}

 

[synapsevampire]

Technical information should be posted:

Crystal version (why would anyone NOT do this???)
Database/connectivity
Example dtaa
Expected output

At any rate, don't say "causing error, state specifically what is being returned in the error". Being new to computers you should understand that error numbers and text are important to pay attention to, and that different versions of software have different features and bugs.

I'm unaware of a 32 char field name limitation, but there could be, especially with older versions.

One fix might be to use a SQL Expression to bring the field in with a shorter name, or place the field in a formula and use the formula.

Again, it depends on the error being returned, the version of Crystal, and the database. It may be that the field is over 254 characters and you're trying to use it in a formula...so many possibilities...so little information

-k