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 »

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 3506 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 3506 times
changing the data band
databand item quantity preview.PNG
databand item quantity preview.PNG (34.96 KiB) Viewed 3506 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 252 times
dummy report.mrt
(211.24 KiB) Downloaded 240 times
databand item.PNG
databand item.PNG (28.46 KiB) Viewed 3506 times
databand item quantity.PNG
databand item quantity.PNG (28.75 KiB) Viewed 3506 times
Lech Kulikowski
Posts: 6163
Joined: Tue Mar 20, 2018 5:34 am

Re: issues using json data with databand

Post by Lech Kulikowski »

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 238 times
Annotation 2020-07-31 145513.png
Annotation 2020-07-31 145513.png (81.73 KiB) Viewed 3505 times
AnthonyClarke
Posts: 2
Joined: Fri Jul 31, 2020 11:17 am

Re: issues using json data with databand

Post by AnthonyClarke »

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: 6163
Joined: Tue Mar 20, 2018 5:34 am

Re: issues using json data with databand

Post by Lech Kulikowski »

Hello

We are always glad to help you!

Thank you.
Post Reply