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.
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.
changing the data band
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.
issues using json data with databand
-
- Posts: 2
- Joined: Fri Jul 31, 2020 11:17 am
issues using json data with databand
- Attachments
-
- newSalesOrder.json
- (28.57 KiB) Downloaded 270 times
-
- dummy report.mrt
- (211.24 KiB) Downloaded 256 times
-
- databand item.PNG (28.46 KiB) Viewed 3922 times
-
- databand item quantity.PNG (28.75 KiB) Viewed 3922 times
-
- Posts: 6301
- Joined: Tue Mar 20, 2018 5:34 am
Re: issues using json data with databand
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.
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 253 times
-
- Annotation 2020-07-31 145513.png (81.73 KiB) Viewed 3921 times
-
- Posts: 2
- Joined: Fri Jul 31, 2020 11:17 am
Re: issues using json data with databand
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.
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.
-
- Posts: 6301
- Joined: Tue Mar 20, 2018 5:34 am
Re: issues using json data with databand
Hello
We are always glad to help you!
Thank you.
We are always glad to help you!
Thank you.