logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
PSandhu  
#1 Posted : Friday, April 12, 2019 1:20:55 AM(UTC)
PSandhu

Rank: Newbie

Groups: Registered
Joined: 4/12/2019(UTC)
Posts: 1
Australia
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
epf  
#2 Posted : Friday, April 12, 2019 7:06:39 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 653
Switzerland

Thanks: 9 times
Was thanked: 111 time(s) in 108 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

thanks 1 user thanked epf for this useful post.
PSandhu on 4/13/2019(UTC)
Users browsing this topic
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.