In ComponentOne, we introduced the C1JsonDataConnector. It enables quick connections to JSON data using ADO.NET or Entity Framework Core. The ComponentOne 22v1 release enhances it further by adding integration of C1JsonDataConnector with FlexReportDesigner. To make it user-friendly, the FlexReportDesigner now supports a direct connection with JSON data sources through the data connection wizard.
In this blog, we will see how we can connect to a JSON data source in FlexReportDesigner and create a C1FlexReport with a JSON Data Source. Let’s open the FlexReportDesigner and create a new empty FlexReport and then follow the sections defined below.
The first step is to create a connection to the JSON data source as follows:
Please refer to the gif below for the above steps.
And just like that, by performing a few steps, we have connected to our JSON Data Source; for this example, we have used the Customers data from northwind.netcore.io.
Now that we have connected to our JSON data source, we can create the layout of our FlexReport as we want. The final report will look similar to the following screenshot showing the data from our JSON data source.
Download the ComponentOne 2022v1 release today and try it yourself.