Seal Report Forum
»
Report Edition
»
Data Source Creation
»
How to create a data source for reading JSON file
Rank: Newbie
Groups: Registered
Joined: 4/12/2019(UTC) Posts: 1  Location: Sydney Thanks: 1 times
|
Hi there,
I have got an application that exports data in JSON format. I want to create customised reports using the data in the JSON file.
Is it possible to read JSON files as data in SealReport? If yes, please provide guidance.
Thanks
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
Yes, you should first create a No SQL Data Source, You have to edit your Definition Script to define the result data table (F8) Then edit the load script (F12): use .Net to read your Json data (refer to https://stackoverflow.co...-a-json-file-in-c-sharp)and fill the datatable you have defined with your data... finally create a model based on this Data Source and select the columns you want to display. Check samples 40,41,42 which shows how to use No SQL Data Source. Good luck. PS: Other approach could be to create a Task that loads your Json data into a table in your database. Edited by user Friday, April 12, 2019 7:17:08 AM(UTC)
| Reason: Not specified
|
 1 user thanked epf for this useful post.
|
|
|
|
Seal Report Forum
»
Report Edition
»
Data Source Creation
»
How to create a data source for reading JSON file
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
