SAP Knowledge Base Article - Public

2559212 - Connecting Crystal Reports to JSON data on ProgreSQL database

Symptom

  • How to connect Crystal Reports Designer to JSON data?

Environment

  • SAP Srystal Reports 2016
  • PostrGreSQL database with JSON data

Reproducing the Issue

  • Create a Report in CR Designer with JSON data
  • Refresh the report and JSON data looks like comma separated string or fails

Cause

  • JSON data requires a special SQL syntax

Resolution

  • Create a Command object connection in Crystal Reports with JSON SQL syntax following the guidelines in:

http://www.postgresqltutorial.com/postgresql-json/

The special operators are: "->" and "->>"

Keywords

KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

Product

SAP Crystal Server 2016