I have 2 DataSets
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;
You need to retrieve the correct data from your DB first and then show it on the report. I suggest amending your query.
I created a view and the passed it to the report
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)