I have 2 DataSets
1: Products
2: ProductsDetails
i have table in the report which it's dataset is ProductDetails. in this table there is a column which has the product id.
i want to show the ProductName instead of the ProductID.
i'm looking for the expression, sth like this in rdlc report:
DBDataContext db = new DBDataContext();
this.currentCellValue = db.tbl_Products.Where(p => p.ID == CurrentCellValue).First().Name;
Thanks