Is there a limit on characters per cell in reports? My report is truncating a TEXT field at 1017 characters

[Berto2002]

I am appending update to custom field 39 throughout a Request lifecycle and can see the content accumulating in the Details section of the Request where I have mapped h_custom_39 in the form design.

When I select h_custom_39 in reports, the output appears to truncate at 1071 chars.

I don't think this should be the case (suspect defect) because:

1. 1017 is an odd number to pick (might expect 1000 or 1024)
2. It's a TEXT/unlimited field so there is some expectation of a much larger capacity then 1017 (being only 4 times the varchar fields capacity)
3. There are various limits listed in the document but no mention here of a truncation of fields of type TEXT: Reports (hornbill.com)

In short, 1017 is too small for a TEXT/unlimited field to truncate at.

[Steve Giller]

49 minutes ago, Berto2002 said:

1017 is an odd number to pick (might expect 1000 or 1024)

The length is in bytes, not characters. Not all characters take only a single byte.

50 minutes ago, Berto2002 said:

It's a TEXT/unlimited field so there is some expectation of a much larger capacity then 1017 (being only 4 times the varchar fields capacity)

The field can take an unlimited number of characters, that does not mean the report will retrieve them all, nor that the outputting file format has the same capabilities (e.g. PDF has it's own restrictions, as do Excel cells.)

I believe the setting reporting.reports.maxFieldLength can be increased to a maximum of 4096 bytes.
I'll see if this setting can be referenced in the documentation.

[Berto2002]

Thanks Steve. I confirm 4096 works to increase the field length and exceeds my current field utilisation. Adding the setting and its limit to docs for future would be useful. Thanks.