Pick row from dataset

[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

[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.