Combining details from two datasets

Hi. I'm just starting to develop reports using Visual Studio 2005 and
Reporting Services 2005 and am still trying to get my head round things. One
immediate problem I could use some advice on is this.
I'm trying to reproduce a report that, in its original incarnation as an asp
page, displayed data returned by two Stored Procedures. The report displayed
the data returned by SP1 in the first 5 columns and for each Group returned
by SP1, SP2 returned an associated figure that was displayed as column 6.
How would I do this in a RS Report since those report objects that are
associated with Datasets - i.e. Tables, Lists and Matrices - can only be
associated with one Dataset?
I'd appreciate any pointers anyone would care to give me on this.
Regards,
YaHozna.You do this with subreport. A subreport can be put into the field of the
table control. First create two reports. The main one with all the data.
Then the report that will be a subreport. Get the second report to work
stand alone first (create it with parameters). Then drag and drop the second
report into a cell of the table object. Do a right mouse click on the sub
report, parameters and bind the parameters to a field of the dataset.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"YaHozna" <YaHozna@.discussions.microsoft.com> wrote in message
news:FE166D20-3F15-43E4-8332-2EE86DB82111@.microsoft.com...
> Hi. I'm just starting to develop reports using Visual Studio 2005 and
> Reporting Services 2005 and am still trying to get my head round things.
> One
> immediate problem I could use some advice on is this.
> I'm trying to reproduce a report that, in its original incarnation as an
> asp
> page, displayed data returned by two Stored Procedures. The report
> displayed
> the data returned by SP1 in the first 5 columns and for each Group
> returned
> by SP1, SP2 returned an associated figure that was displayed as column 6.
> How would I do this in a RS Report since those report objects that are
> associated with Datasets - i.e. Tables, Lists and Matrices - can only be
> associated with one Dataset?
> I'd appreciate any pointers anyone would care to give me on this.
> Regards,
> YaHozna.|||Bruce, many thanks. That worked perefectly. I wonder if I might presume upon
your patience once more? I can't seem to set the formatting of the subreport
cell in my table to match the rest of the row, which is a different colour
and font. I've tried changing the formatting of the subreport but to no
avail. Is there a way to do this?
Regards,
YaHozna.
"Bruce L-C [MVP]" wrote:
> You do this with subreport. A subreport can be put into the field of the
> table control. First create two reports. The main one with all the data.
> Then the report that will be a subreport. Get the second report to work
> stand alone first (create it with parameters). Then drag and drop the second
> report into a cell of the table object. Do a right mouse click on the sub
> report, parameters and bind the parameters to a field of the dataset.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "YaHozna" <YaHozna@.discussions.microsoft.com> wrote in message
> news:FE166D20-3F15-43E4-8332-2EE86DB82111@.microsoft.com...
> > Hi. I'm just starting to develop reports using Visual Studio 2005 and
> > Reporting Services 2005 and am still trying to get my head round things.
> > One
> > immediate problem I could use some advice on is this.
> >
> > I'm trying to reproduce a report that, in its original incarnation as an
> > asp
> > page, displayed data returned by two Stored Procedures. The report
> > displayed
> > the data returned by SP1 in the first 5 columns and for each Group
> > returned
> > by SP1, SP2 returned an associated figure that was displayed as column 6.
> >
> > How would I do this in a RS Report since those report objects that are
> > associated with Datasets - i.e. Tables, Lists and Matrices - can only be
> > associated with one Dataset?
> >
> > I'd appreciate any pointers anyone would care to give me on this.
> >
> > Regards,
> >
> > YaHozna.
>
>|||You need to do the formatting in the subreport, not for the cell in the
master report.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"YaHozna" <YaHozna@.discussions.microsoft.com> wrote in message
news:DE1CEE92-572C-446F-9C17-85E7C4D3F19D@.microsoft.com...
> Bruce, many thanks. That worked perefectly. I wonder if I might presume
> upon
> your patience once more? I can't seem to set the formatting of the
> subreport
> cell in my table to match the rest of the row, which is a different colour
> and font. I've tried changing the formatting of the subreport but to no
> avail. Is there a way to do this?
> Regards,
> YaHozna.
>
> "Bruce L-C [MVP]" wrote:
>> You do this with subreport. A subreport can be put into the field of the
>> table control. First create two reports. The main one with all the data.
>> Then the report that will be a subreport. Get the second report to work
>> stand alone first (create it with parameters). Then drag and drop the
>> second
>> report into a cell of the table object. Do a right mouse click on the sub
>> report, parameters and bind the parameters to a field of the dataset.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "YaHozna" <YaHozna@.discussions.microsoft.com> wrote in message
>> news:FE166D20-3F15-43E4-8332-2EE86DB82111@.microsoft.com...
>> > Hi. I'm just starting to develop reports using Visual Studio 2005 and
>> > Reporting Services 2005 and am still trying to get my head round
>> > things.
>> > One
>> > immediate problem I could use some advice on is this.
>> >
>> > I'm trying to reproduce a report that, in its original incarnation as
>> > an
>> > asp
>> > page, displayed data returned by two Stored Procedures. The report
>> > displayed
>> > the data returned by SP1 in the first 5 columns and for each Group
>> > returned
>> > by SP1, SP2 returned an associated figure that was displayed as column
>> > 6.
>> >
>> > How would I do this in a RS Report since those report objects that are
>> > associated with Datasets - i.e. Tables, Lists and Matrices - can only
>> > be
>> > associated with one Dataset?
>> >
>> > I'd appreciate any pointers anyone would care to give me on this.
>> >
>> > Regards,
>> >
>> > YaHozna.
>>|||Seems to be displaying old subreport formatting in the main report that has
subsequently been changed. However I shall persevere :)
Many thanks for the help.
Regards,
YaHozna.
"Bruce L-C [MVP]" wrote:
> You need to do the formatting in the subreport, not for the cell in the
> master report.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "YaHozna" <YaHozna@.discussions.microsoft.com> wrote in message
> news:DE1CEE92-572C-446F-9C17-85E7C4D3F19D@.microsoft.com...
> > Bruce, many thanks. That worked perefectly. I wonder if I might presume
> > upon
> > your patience once more? I can't seem to set the formatting of the
> > subreport
> > cell in my table to match the rest of the row, which is a different colour
> > and font. I've tried changing the formatting of the subreport but to no
> > avail. Is there a way to do this?
> >
> > Regards,
> >
> > YaHozna.
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> You do this with subreport. A subreport can be put into the field of the
> >> table control. First create two reports. The main one with all the data.
> >> Then the report that will be a subreport. Get the second report to work
> >> stand alone first (create it with parameters). Then drag and drop the
> >> second
> >> report into a cell of the table object. Do a right mouse click on the sub
> >> report, parameters and bind the parameters to a field of the dataset.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "YaHozna" <YaHozna@.discussions.microsoft.com> wrote in message
> >> news:FE166D20-3F15-43E4-8332-2EE86DB82111@.microsoft.com...
> >> > Hi. I'm just starting to develop reports using Visual Studio 2005 and
> >> > Reporting Services 2005 and am still trying to get my head round
> >> > things.
> >> > One
> >> > immediate problem I could use some advice on is this.
> >> >
> >> > I'm trying to reproduce a report that, in its original incarnation as
> >> > an
> >> > asp
> >> > page, displayed data returned by two Stored Procedures. The report
> >> > displayed
> >> > the data returned by SP1 in the first 5 columns and for each Group
> >> > returned
> >> > by SP1, SP2 returned an associated figure that was displayed as column
> >> > 6.
> >> >
> >> > How would I do this in a RS Report since those report objects that are
> >> > associated with Datasets - i.e. Tables, Lists and Matrices - can only
> >> > be
> >> > associated with one Dataset?
> >> >
> >> > I'd appreciate any pointers anyone would care to give me on this.
> >> >
> >> > Regards,
> >> >
> >> > YaHozna.
> >>
> >>
> >>
>
>