Solved

Can I use multiple datasets in a single SSRS report

Posted on 2012-03-19
4
443 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
I got part of the answer
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Time Corrections for Reports Working with a report, we made some interesting discoveries about the time corrections/updates We are using the following Parameters: Starting Entered Date (Date) formatted as Data type: "Date/Time" Ending Entered …
Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

744 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now