Using linq or other queries in report expressions

**Andrus** · Mar 29 '08, 08:55 PM

I'm using WinForms ReportViewer control in local mode.

I need to allow report creators to create fields containing data
from related tables.

Best way for this would be to use linq in report expressions like

=db.Customers.S ingleOrDefault( x =x.CustomerID ==
Fields!Customer ID.Value).Name

Unfortunalely, engine does not allow such expressions and this is too long.
How to use data from related tables in reports ?

Andrus.