MS Reporting Services question

Posted on 2007-07-19
Last Modified: 2010-08-05
VS 2005  BI Tools
SQLServer 2005

Hi is it possible to create a datasource that points to several schemas?
Is it possible to create a dataset the that pulls data from several datasources?

if either of these are possible then please give directions on how to do it.

Question by:deNZity
    LVL 22

    Expert Comment

    Use subreports!

    Author Comment

    Thanks for the reply,

    I can do it in a dataset via query.
    LVL 22

    Accepted Solution

    Dear deNZity,
    Create your main report from 1ºdatasource, after that, create a new report (subreport) with the other datasource.
    After, in the main report go to tollbox and add the subreport item... configure it... select the subreport filename and the parameters in the respective tab...

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Suggested Solutions

    by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
    I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    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.

    745 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

    17 Experts available now in Live!

    Get 1:1 Help Now