Change Request Summary Report Description

[mwaite]

When I run the Change Summary Report the Description field is empty. We reverted our change objects back from Rich Text fields to basic text fields when the Rich Text was pushed out in Windchill 11.

I found a post with the same problem here:
https://community.ptc.com/t5/Windchill/Change-Request-Summary-report-Description/m-p/810977

In the old post, the reports were pulling the plain text fields, and the user was using the Rich Text.

Now it seems like PTC has changed the reports to pull the Rich Text instead of the plain text. We don't want to use the Rich Text fields.  They don't add any value, and they can't be read with common report tools like SSRS.

Has anyone found a way to have the new reports pull the original fields?

Has anyone found a way to have SSRS read the blob? (We've looked at it and it isn't stored as RTF.  PTC does something to it before they store it.  Maybe compress it?  I read in WCH that the RTF fields are left out of tables because of the performance impact.

[avillanueva]

If its JSP, you will likely have to customize and mod the report. I converted to rich text and since I had a custom JSP page I had to call out the attribute for the rich text description:

<jca:renderPropertyPanel model="${ecnInfoModel}">
<jca:addProperty property="longDescription.formattedText"/>
</jca:renderPropertyPanel>

I believe the normal description name is just "description". Trying finding that in the report generation and modify the call out. Just know you will fight this battle in the future as they push out more rich text fields. 

This is from the attributes list for that object.

[Marco_Tosin]

I have a couple of reports that also extract the rich text description but the problem is that the string does not wrap and so it is very long to see in the results.

In the query builder I use only the highlighted attribute