issues using json data with databand

Stimulsoft Dashboards.WIN discussion
Post Reply
AnthonyClarke
Posts: 2
Joined: Fri Jul 31, 2020 11:17 am

issues using json data with databand

Post by AnthonyClarke » Fri Jul 31, 2020 11:57 am

Good Afternoon i'm hoping someone can provide assistance I have json data-source i have imported into the Stimulsoft Designer version 2020.3.2.


I can see that on import it has separated the children of the order item.
json data srouce.PNG
json data srouce.PNG (2.85 KiB) Viewed 63 times
I have encountered an issue where trying to create a report using a data band using the order item as a data source appears to ignore the differing sizes defaulting the sizes displayed to be the ones of the first size available in the order_item_quantity.
databand item preview.PNG
databand item preview.PNG (33.32 KiB) Viewed 63 times
changing the data band
databand item quantity preview.PNG
databand item quantity preview.PNG (34.96 KiB) Viewed 63 times
source to be the item quantity provides information from the first product for every size displayed.

i have tried to make a relationship between the two sources however nothing appears to have changed. is there something i am doing incorrectly or do we need to make a change to the json data.

I have attached an the report and the json of the sales order.
Attachments
newSalesOrder.json
(28.57 KiB) Downloaded 18 times
dummy report.mrt
(211.24 KiB) Downloaded 8 times
databand item.PNG
databand item.PNG (28.46 KiB) Viewed 63 times
databand item quantity.PNG
databand item quantity.PNG (28.75 KiB) Viewed 63 times
Lech Kulikowski
Posts: 2707
Joined: Tue Mar 20, 2018 5:34 am

Re: issues using json data with databand

Post by Lech Kulikowski » Fri Jul 31, 2020 12:56 pm

Hello,

In that case, you can use master-detail construction and set DataRelation and MasterComponent properties.
https://www.stimulsoft.com/en/documenta ... _lists.htm

Thank you.
Attachments
dummy report_modified.mrt
(184.2 KiB) Downloaded 8 times
Annotation 2020-07-31 145513.png
Annotation 2020-07-31 145513.png (81.73 KiB) Viewed 62 times
AnthonyClarke
Posts: 2
Joined: Fri Jul 31, 2020 11:17 am

Re: issues using json data with databand

Post by AnthonyClarke » Fri Jul 31, 2020 1:48 pm

perfect thank you.

I also found that i didn't use the relationship properly and just referenced the field from the wrong place, but this makes sense thank you very much.
Lech Kulikowski
Posts: 2707
Joined: Tue Mar 20, 2018 5:34 am

Re: issues using json data with databand

Post by Lech Kulikowski » Sun Aug 02, 2020 9:39 am

Hello

We are always glad to help you!

Thank you.
Post Reply