Linking and sorting multiple datasets in a single report

Hi,
I have got a report which uses two different datasets that combined
give me the required output. I am now required to combine the two
datasets into a single data region and sequence it appropriately. Is
there an easy way to do this within reporting services?
The sources of the datasets are stored proc's with about 3000 lines of
code in each. I could combine the two to give me the desired sequenced
results but this will require a lot of work and testing to ensure
everything still works correctly. Surely there must be an easy way to
achieve this without having to resort to this.
Thanks in advance.
VaughanFor a 1:1 or a 1:M you should use subreports. Subreports are really the only
way to tie two datasets together.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Vorno" <vaughank@.hotmail.com> wrote in message
news:1166404556.499638.139780@.n67g2000cwd.googlegroups.com...
> Hi,
> I have got a report which uses two different datasets that combined
> give me the required output. I am now required to combine the two
> datasets into a single data region and sequence it appropriately. Is
> there an easy way to do this within reporting services?
> The sources of the datasets are stored proc's with about 3000 lines of
> code in each. I could combine the two to give me the desired sequenced
> results but this will require a lot of work and testing to ensure
> everything still works correctly. Surely there must be an easy way to
> achieve this without having to resort to this.
> Thanks in advance.
> Vaughan
>|||Thanks Bruce, I'll give it a try. Cheers
Bruce L-C [MVP] wrote:
> For a 1:1 or a 1:M you should use subreports. Subreports are really the only
> way to tie two datasets together.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Vorno" <vaughank@.hotmail.com> wrote in message
> news:1166404556.499638.139780@.n67g2000cwd.googlegroups.com...
> > Hi,
> >
> > I have got a report which uses two different datasets that combined
> > give me the required output. I am now required to combine the two
> > datasets into a single data region and sequence it appropriately. Is
> > there an easy way to do this within reporting services?
> >
> > The sources of the datasets are stored proc's with about 3000 lines of
> > code in each. I could combine the two to give me the desired sequenced
> > results but this will require a lot of work and testing to ensure
> > everything still works correctly. Surely there must be an easy way to
> > achieve this without having to resort to this.
> >
> > Thanks in advance.
> >
> > Vaughan
> >

linked subreports

Hello!

I'm using stored procedure, that output several rows.
Is it possible to make single linked subreport , that could be called from each record of main report and the record value is shared with subreport which shows detail information about (execute query with parameter = record value) ? If it is not, any ideas how to realize?Why cant you use two queries in the same sp using joins so that you will avoid this problem?|||Thanks for answer.

Actualy, i have solved problem by using subreport control in details section. Also i couldn't found how to hide the name of subreport control, therefor i've removed its name afterwards the name of report tabs were hidden. It's not big problem.

So, i can't use joins , because data could be joined.

Best Regards