Stimulsoft Business Intelligence System | Forum

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.

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.

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.

Hello

We are always glad to help you!

Thank you.