Missing first row while loading table from json datasource

[Bharathwajan]

 

Hey community,

  I am using JSON as my report's data source  which has the below given format

 

Quote

{     "Data": [       {         "parent_service_code": "Payments service code 1",         "service_code": "Service Code 1",         "Charge Code": "charge code 1",         "No of TX": "74",         "Price D/C": "0,56",         "Total D/C": "23"       },       {         "parent_service_code": "Payments service code 1",         "service_code": "Service Code 1",         "Charge Code": "charge code 1",         "No of TX": "74",         "Price D/C": "0,56",         "Total D/C": "23"       } ] }

then i had created

•     a dataset with the json datasource   
•     table(utilizing the dataset)   

  This table always ignores the first record .I had verified that the first record is loaded properly from the "Dataset and Query Dialog" window and all the fields are identified properly.

  There is similar case reported earlier "Ref. Case #00051723" but that solution is not relevant in my case ,Since I am not using any sub reports.

[Domenico Donofrio]

Hello Bharathwajan,

please find in attachment a table that is using the json as datasource. I have only modified the second row to show that is a different record.

The Dataset1 used by the table is holding the link with the Json_data_adapter.jrdax that uses the Json file.

 

 

json_table.zip