This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Remove From My Forums

Multiple Dataset in rdlc

Question
0

Sign in to vote

Hi All

Is it posible to use two or more dataset in a rowdetail of a report?

I have a report with a table to show data

All columns came from a dataset except one that would come from a new dataset(key_value table)

But in the rowdetail Icannot use that

Monday, July 2, 2012 3:37 PM

Answers

0

Sign in to vote
which version are you using? If you are using 2008 R2 or higher, you can use the SSRS lookup function.

http://msdn.microsoft.com/en-us/library/ee210531.aspx
- Proposed as answer by Syed Qazafi Anjum Monday, July 2, 2012 10:44 PM
- Marked as answer by Edward Zhu Friday, July 13, 2012 10:03 AM
Monday, July 2, 2012 3:39 PM

All replies

0

Sign in to vote
which version are you using? If you are using 2008 R2 or higher, you can use the SSRS lookup function.

http://msdn.microsoft.com/en-us/library/ee210531.aspx
- Proposed as answer by Syed Qazafi Anjum Monday, July 2, 2012 10:44 PM
- Marked as answer by Edward Zhu Friday, July 13, 2012 10:03 AM
Monday, July 2, 2012 3:39 PM
0

Sign in to vote

Try with this:

=(Fields!XXX.Value, "DataSet")

Only you can use this with a Sum, Min, Max, First, Last, etc.

Gracias Ing. Salomon Bagdadi

Monday, July 2, 2012 6:54 PM