Solved

Can I use multiple datasets in a single SSRS report

Posted on 2012-03-19
4
466 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 40

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 40

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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Written by Valentino Vranken. Introduction: In a previous article (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Reporting-On-Data-From-Stored-Procedures-part-1.html) I announced that I would writ…
Introduction: This article is aimed at report developers who are used to developing reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Ser…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

752 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