Bharathwajan Posted February 19 Share Posted February 19 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. Link to comment Share on other sites More sharing options...
Domenico Donofrio Posted February 29 Share Posted February 29 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now