Relation 1-n wont work
Posted: Mon Oct 14, 2019 9:39 am
Hello,
I need some help as using Stimulsoft Designer .NET;
First of all, I have a XML Datasource with some "tables" which could be structured like this:
I have a Databand with datasource as "Lines" (relation "parent/child": item.id/lines.itemId).
For each lines, I'm displaying item's information such as description, price etc.
But I also have to display discount's information so I tried to add a relation on "Lines" (relation "parent/child": discounts.linesId/lines.id).
Since I can have multiple discounts per lines, it looks like it wont work because it gets only the first discounts and not all of them.
I also tried to put another databand as "Discounts" and make "SumIf condition" on Line's databand but I need another condition on the lines id so I get the exact discount for my transaction line and I dont know if I can do that.
Would someone know how I can make it work if my need is correctly detailed.
Thanks for your help,
Prinzae
I need some help as using Stimulsoft Designer .NET;
First of all, I have a XML Datasource with some "tables" which could be structured like this:
Code: Select all
<transaction>
<lines>
<item>
</item>
<discounts>
</discounts>
<discounts>
</discounts>
</lines>
<lines>
[...]
</lines>
</transaction>For each lines, I'm displaying item's information such as description, price etc.
But I also have to display discount's information so I tried to add a relation on "Lines" (relation "parent/child": discounts.linesId/lines.id).
Since I can have multiple discounts per lines, it looks like it wont work because it gets only the first discounts and not all of them.
I also tried to put another databand as "Discounts" and make "SumIf condition" on Line's databand but I need another condition on the lines id so I get the exact discount for my transaction line and I dont know if I can do that.
Would someone know how I can make it work if my need is correctly detailed.
Thanks for your help,
Prinzae