Crystal Reports & JSON Data Sources

[Former Member]

Does Crystal Reports 2008, 2011, or 2013 support reading data from online JSON feeds as it can with XML feeds?  In other words, can I build a report using an online JSON data source?

[Former Member]

If the JSON data source is MongoDB, there is a solution from DataDirect (connectivity partner for Crystal Reports): https://www.progress.com/data-sources/mongodb

Regarding XQuery, I have contact the product manager to respond to this thread on XQuery and JSON support.

[Former Member]

I am currently accessing a JSON (BSON) data base called MongoDB with an ODBC connector.  Currently there are two that I am evaluating - RSSBus ADO.NET Data Providers, (http://www.rssbus.com/ado) and Simba Technology (www.simba.com).

The Simba ODBC connector can go down 7 levels of nested records for reading and 5 levels for writing.  RSSBus ODBC can go down 3 levels, although I have only used the first level.

In any case, using either ODBC connector feeds the data to Crystal as though it is a flat file.

One word of caution.  Since JSON (non-SQL data base records) typically have a very high volume of data, try to avoid using formulas and data manipulation at the client end.  Get the query to give you what to need, otherwise it might be slow.

Richard Sigrist

Northern Light SinglePoint

[JWiseman]

hi Matthew,

right now, only crystal reports for enterprise via the restful services sdk.

https://help.sap.com/businessobject/product_guides/boexir4/en/xi4sp6_cr_restful_ws_en.pdf

-jamie

[JWiseman]

p.s. not sure if datadirect xquery (progress) would allow you to connect crystal (2008 etc.) to json or not...the cr installation does come with a bunch of datadirect drivers but not this one. you would need to contact progress to find out if that would work if you can't get verification on this forum from someone that's tried it.