How to connect Crystal Reports Designer to JSON data?
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
- JSON data requires a special SQL syntax
- Create a Command object connection in Crystal Reports with JSON SQL syntax following the guidelines in:
The special operators are: "->" and "->>"
KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To
SAP Crystal Server 2016