[Last Call] Learn how to a build a cloud-first strategyRegister Now

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

MS Reporting Services question

VS 2005  BI Tools
SQLServer 2005

Hi is it possible to create a datasource that points to several schemas?
or
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.



TIA
0
deNZity
Asked:
deNZity
  • 2
1 Solution
 
PedroCGDCommented:
Use subreports!
Regards!
0
 
deNZityAuthor Commented:
Thanks for the reply,

I can do it in a dataset via query.
0
 
PedroCGDCommented:
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...
Helped?
regards!!
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

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