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.
How can I add a CLOB field in Jaspersoft Studio and display it as String in the report in Clarity?
Article ID: 144581
Updated On:
Products
Clarity PPM On Premise
Issue/Introduction
I am trying to add CLOB field in Jaspersoft Studio, when I look in the report it just shows an Oracle field reference but not the actual text value. How can I display the file as a String?
Environment
Release : All Supported Releases with Clarity
Component : CA PPM JASPERSOFT
Resolution
There are few things you can do to call the field and convert to String. We recommend using Java as described here:
https://community.jaspersoft.com/questions/538454/how-convert-clob-varchar2
Check out the attached file for an example how it will look into Studio.
Attachments
Feedback
Yes
No
Powered by
