Reduce the total characters in a field in a Jaspersoft report

book

Article ID: 211849

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

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?

Environment

CLARITY JASPERSOFT

Resolution

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.