Click here to Skip to main content
13,556,387 members
Rate this:
Please Sign up or sign in to vote.
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;

Posted 18-Jan-13 1:40am
Rate this: bad
Please Sign up or sign in to vote.

Solution 1


You need to retrieve the correct data from your DB first and then show it on the report. I suggest amending your query.
HamidNoahdi 22-Jan-13 16:36pm
Yes, you are right, i created a view and passed it to a datasource in report
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

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)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web02 | 2.8.180515.1 | Last Updated 22 Jan 2013
Copyright © CodeProject, 1999-2018
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100