Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 487
  • Last Modified:

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?
0
himabindu_nvn
Asked:
himabindu_nvn
  • 2
3 Solutions
 
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
 
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
 
himabindu_nvnAuthor Commented:
I got part of the answer
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now