Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# VB.NET Reports RDL RDLC , +
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
Posted 18-Jan-13 2:40am
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

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

Solution 2

I created a view and the passed it to the report
  Permalink  

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

  Print Answers RSS
0 OriginalGriff 381
1 Sergey Alexandrovich Kryukov 245
2 Marcin Kozub 225
3 Praneet Nadkar 217
4 /\jmot 189
0 OriginalGriff 8,284
1 Sergey Alexandrovich Kryukov 7,407
2 DamithSL 5,614
3 Maciej Los 4,989
4 Manas Bhardwaj 4,986


Advertise | Privacy | Mobile
Web04 | 2.8.1411023.1 | Last Updated 22 Jan 2013
Copyright © CodeProject, 1999-2014
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