You can follow any responses to this entry through the RSS 2.0 feed.
You can skip to the end and leave a response. Pinging is currently not allowed.
Menu
- Application integration: reorganise, recycle, repurpose
- Closing out the year
- Wildly Over-ambitious Book Title of the Week
- Handling errors in tabular forms - don't forget the commit...
- 5 Cool Things you can do with HTML5 (p4)
- 5 Cool Things you can do with HTML5 (p3)
- Tech Article: How I Got Started With The Btrfs File System for Oracle Linux
- Case Study: How We Improved SAN and NAS Performance with Oracle Database Hybrid Columnar Compression
- Take the 2012 Database Management Survey
- Tech Article: Which Tool Should I Use to Manage Which Virtualization Technology?
- Article: How to Deploy Oracle RAC 11.2.0.3 on Zone Clusters
- New on BAOA: Using RTE enabled fields in BI Publisher with PeopleTools 8.52 goo.gl/QX3tr 6 days ago
- New on BAOA: Oracle PeopleSoft PeopleTools 8.53 Release Value Proposition goo.gl/NUFQ5 6 days ago
- I’m Speaking at Oracle OpenWorld. Join Me. goo.gl/fb/H5El6 1 week ago
- Direct Reports and loading the component goo.gl/fb/jF3bt 4 weeks ago
- Oracle UPK (User Productivity Kit) – Chapter 5. Editing a UPK topic with the developer. goo.gl/fb/wmUcy 1 month ago
Using RTE enabled fields in BI Publisher with PeopleTools 8.52
In PeopleTools 8.50 adding a Rich Text Editor to Long fields was introduced. With this RTE users are able to actually format text like you would do in for example Microsoft Word. This was a great feature for online entry and presentation in PeopleSoft. Unfortunately this does have a downside. The text that is entered and formatted using RTE gets stored in the database as HTML. This means that when you are using PSQuery to query the data, the data is presented as plain text with the HTML tags and therefor also not usable in any BI Publisher reporting.
With PeopleTools 8.52 a new tempate is introduced that solves this issue and renders the HTML tags in the Long field to the actual formatting the same way as presented in online PeopleSoft.
Enable Rich Text Editor
First you need to enable a Long field with the Rich Text Editor. After starting Application Designer, open the page that contains a long field and open the properties. On the Options Tab of the field properties, you can enable the RTE as shown in the following picture.
Now when you enter the text as show in the screenshot it will be stored in the database with HTML formatting. If you would create a PSQuery on this field, it will the return the text as plain text with HTML tags like shown in the following screenshot.
Pre-PeopleTools 8.52 Processing
When you would create a template and add the RTE enabled field to the template the text would be presented as plain text without formatting.
Template example
Output
When you would create a Report Definition and run the report, it would result in the following output.
PeopleTools 8.52 Processing
With PeopleTools 8.52 the template HTML_SUB is introduced. This is in fact a XSL that will transform and render the HTML tags in the RTE enabled field from PSQuery and present the text in the BI Publisher output including the formatting.
First thing that needs to be done, is importing the subtemplate in the main template by adding the following line:
After this right click on the RTE enabled field and choose properties and enter the following code:
See following screenshot of the template as an example:
Now open the Report Definition and go to tab Properties. From the Property Group dropdown select PeopleTools Settings and enter all fields that are RTE enabled in the psxp_nocdatafields property. This will remove the CDATA block that PSQuery generates.
Now when you run the report it will format the text according the formatting used by the user with RTE.
If you want to be able to run a preview straight from Word, you need to save the PSXP_xhtml2fo.xsl locally from the content library (to be found with subtemplate HTML_SUB) and change the import of the subtemplate HTML_SUB, to the following:
In above example PSXP_xhtml2fo.xsl is saved to the root of the c drive.
Viewed 373 times by 194 visitors
Related posts: