Solved

Can I use multiple datasets in a single SSRS report

Posted on 2012-03-19
4
451 Views
Last Modified: 2012-03-25
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
Comment
Question by:himabindu_nvn
  • 2
4 Comments
 
LVL 39

Assisted Solution

by:lcohan
lcohan earned 334 total points
ID: 37739712
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
 
LVL 39

Assisted Solution

by:lcohan
lcohan earned 334 total points
ID: 37739719
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
 
LVL 25

Accepted Solution

by:
TempDBA earned 166 total points
ID: 37744470
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
 

Author Closing Comment

by:himabindu_nvn
ID: 37762881
I got part of the answer
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question