Page 1 of 1

Pick row from dataset

Posted: Mon Sep 22, 2014 1:26 pm
by ChrDressler
Hi,

I have a special issue. A report uses two datasets:
- Customer (Id, Name, Score)
- Comments (ScoreFrom, ScoreTo, Text)

I want to print the Text from Comments matching Customer's scrore. (each customer get a text depending on his score)
In C#, I can write to search: (pseudo-code)
comment = comments.where(p => p.ScroreFrom >= Customer.Scrore && p.ScroreTo <= Customer.Scrore)

Question: How can I realize this "search"-script in the report designer?

Regards,
Christoph

Re: Pick row from dataset

Posted: Tue Sep 23, 2014 10:23 am
by Alex K.
Hello,

Please try to add the Relation between data sources in report dictionary and try to use the master-detail construction.

Thank you.