Pick row from dataset
Posted: Mon Sep 22, 2014 1:26 pm
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
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