Report not showing all text

[lomixture]

On a report we have built, we have a question from a Intelligent Capture which uses a multi line text box for its free-text answer.

This question is pulled into the report, but not in its entirety. It appears each answer is only pulling 255 characters from the free-text answer into the excel download of the report. I have tried CSV and XLSX but neither provides different results.

Is there somewhere in the settings we can increase the characters allowed in a text box, and I believe Excel allows far more characters for a single cell.

Thanks in advance

[lomixture]

Any ideas?

[lomixture]

@Victor , do you perhaps have an idea?

[Graham]

@lokent

The maximum length of a field on the reports is controlled by the value of the

reporting.reports.maxFieldLength

setting. What value is that set to?

Graham
 

[lomixture]

@Grahamit's currently set to 1024? I did a dip test of the report and none of the fields that I checked had pulled more than 255 characters (inc spaces).

[Graham]

@lokent Hmmm.. That's not what I was expecting! 

So, maybe my assumptions are wrong. How are you creating and running the report?

[lomixture]

@Graham I've sent you the definition file if that helps?

[lomixture]

I've noted on the report that they're all pulling from lettered custom fields, if that has any say in it.

[Steve Giller]

Are they from h_custom_a - h_custom_o, by any chance?
These are VARCHAR/255 fields, see the notes: VARCHAR custom fields a - o each suitable for holding up to 255 characters of any type.

See the Mapping Fields from Customised Forms wiki page for more details.

[lomixture]

@Steve Giller Most of them are! I seem to be coming across more and more issues relating to custom fields.

[lomixture]

So switching to custom_p-t should fix the issue?

[lomixture]

@Steve Giller @Graham Now I've remapped a lot of the custom fields for character reasons, is there a way of rejigging the report so previously logged information aligns with their new custom field and column on reports? As I've had to reuse some custom fields previously used elsewhere within the int-cap, it's showing dates in the wrong columns etc.