Can I use multiple datasets in a single SSRS report

I need to generate an SSRS report. It is a drill down report. But I have to get data from multiple cubes. So what is the best way to combine the results from multiple data sets.

For suppose, I have 3 cubes. From these three cubes I create 3 data sources. And from here 3 data sets. I need to create a dril down report from these datasets. How should I?
himabindu_nvnAsked:
Who is Participating?
 
TempDBACommented:
It would be great if you elaborate your requirement a little more. Like whether you want to show full data into a single table, or there is any dependency with the reports, etc.
0
 
lcohanDatabase AnalystCommented:
Sure, for instance just edit the report in BIDS then select and click "Report Data" from the View menu - last option - right click and "Add dataset..."
0
 
lcohanDatabase AnalystCommented:
You could also create one report for each data set/source then link them all into one report above all three single reports.

http://msdn.microsoft.com/en-us/library/ms156327(v=sql.90).aspx
http://msdn.microsoft.com/en-us/library/ms155998.aspx
0
 
himabindu_nvnAuthor Commented:
I got part of the answer
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.