Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 Using multiple stored procedures in one report

Author  Topic 

mustafamisir
Starting Member

2 Posts

Posted - 2005-08-11 : 02:21:54
Hi all,

I want to use 2 stored procedures in one report, but I could not find what is the way of doing this. I searched this subject on the intrernet, and I found some solutions. However, they used stored procedures in one stored procedure and used in one report. This is not the thing which I want to do, I want only do using 2 stored procedures in one report at the same time.

Thanks, for now...

gcowhsu
Starting Member

38 Posts

Posted - 2005-08-11 : 11:21:28
have more then one dataset
Go to Top of Page

mustafamisir
Starting Member

2 Posts

Posted - 2005-08-12 : 02:26:28
How can I use more than one datasheet.
Go to Top of Page

gcowhsu
Starting Member

38 Posts

Posted - 2005-08-12 : 17:45:14
If you click on the Dataset tab you will see a drop down for the datasets. The last item is called new dataset, click that.
Go to Top of Page

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2005-08-12 : 18:59:34
And then you need to design your report so that it the containers like table and list are defined as to which dataset they use. A container cannot reference more than one dataset, but you can have multiple containers which reference different datasets.

---------------------------
EmeraldCityDomains.com
Go to Top of Page
   

- Advertisement -