A multilevel pivot report with a query condition including the 'Before' date/time operator fails exporting to PDF.

Steps to Reproduce

  1. Create a report of type Multilevel Pivot containing a 'Before' condition on a date/time field, for example the one shown below:

  2. Export to PDF.

    Notice the error on the page and in the server log:
    Interactive report format error: org.json.JSONException: A JSONObject text must begin with '{' at character 1 of undefined:


This issue is fixed in all currently supported versions. Please review the Fixed In section to determine the latest available patch your instance can be upgraded to.

The workaround on previous releases consisted in the following:

1 - Load the affected report

2 - Click on the "cog" wheel on the top right of the page

3 - Select the option "Printer friendly version"

4 - Press "ctrl - p" to open your printer driver and select "Save as PDF". Please note this will not include the report header (Title, Table, Run By, etc) on the PDF.


Related Problem: PRB1248441

Seen In

Jakarta Patch 6

Fixed In

Jakarta Patch 10
Kingston Patch 8

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2020-11-16 05:15:03