ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Reduce the total characters in a field in a Jaspersoft report


Article ID: 211849


Updated On:


Clarity PPM SaaS


Requesting your support to know the limitation of use of Jaspersoft, because it is required to know if it is possible to reduce the total of characters in a report. In a custom report in the field the total of characters is 80 and 50 is required, is this possible?




As per Tibco, you can try to achieve this in the following way:

1) In Advanced Reporting Ad Hoc view on the left side on the blue panel where it says "Fields" press the icon next to it, then select Create Calculated Field.

2) In the calculated field formula type: Mid("FIELDNAME",1,50)

3) Replace FIELDNAME with a field name you want to cut. Then press validate and if it's green, add the field to your report.