Troubleshooting custom reports and tips

Preview the report or JSON file

Use the Accept setting in the Post request Report API to view the resulting file as a JSON file, a Word/Excel document, or a PDF document. This enables you to track and view the faulty report in any of the three of the report stages:

The Report JSON file
The Word/Excel document
The PDF document

Tip: You can also use Fiddler (or other 3rd party Web debugging tools) to create and verify your reports.

Reports with included document contents

If you want the report to include document contents, the report request must contain the following parameter IncludeDocumentContents=true.

See the Report API documentation.

Additionally, the following fields must be specified in the OData queries of the Report JSON file so that the PDF engine can recognize the document and retrieve the fields.

RecordKey
State_Value

The date is not displayed in the expected format

Please see the solution here.