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