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