Click here to Skip to main content
15,881,882 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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:

C#
DBDataContext db = new DBDataContext();
this.currentCellValue = db.tbl_Products.Where(p => p.ID == CurrentCellValue).First().Name;

Thanks
Posted

Hi,

You need to retrieve the correct data from your DB first and then show it on the report. I suggest amending your query.
 
Share this answer
 
Comments
Hamid Noahdi 22-Jan-13 16:36pm    
Thanks.
Yes, you are right, i created a view and passed it to a datasource in report
I created a view and the passed it to the report
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900