Using more then one dataset

Hey,

Is there any way to use more then one stored procedure, or a stored
procedure that returns 2 datatables or 2 datasets in one report, the same
report?

Thanks

Bruce
Mon Jan 17 10:27:11 CST 2005

You can have multiple datasets in a report but you can not join those
datasets in a report. The stored procedure can only return one dataset for
RS (RS does not support multiple being returned).


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

"Spencer23" <Spencer23@discussions.microsoft.com> wrote in message
news:FBBF307E-2276-4AC8-97BB-D7D8F33B17EE@microsoft.com...
> Hey,
>
> Is there any way to use more then one stored procedure, or a stored
> procedure that returns 2 datatables or 2 datasets in one report, the same
> report?
>
> Thanks

Spencer23
Mon Jan 17 10:39:03 CST 2005

Hi Bruce,

How could multiple datasets be used in the same report?

Thanks

"Spencer23" wrote:

> Hey,
>
> Is there any way to use more then one stored procedure, or a stored
> procedure that returns 2 datatables or 2 datasets in one report, the same
> report?
>
> Thanks

Bruce
Mon Jan 17 10:50:04 CST 2005

You can create multiple datasets in the data tab. In layout you can add
multiple tables and then pick the dataset and add the fields to the table.
You can only have one dataset with the wizard but when working manually you
can create as many datasets as you want. Note that a table can only use a
single dataset, ditto for list, matrix, chart. Also note that you can use
the same dataset multiple times. For instance I have used a dataset and
charted it three different ways plus showed the data used. So I had three
charts and one table on the report, all three used the same dataset but they
didn't have to, I could have used three different datasets. There are a lot
of things that can be done that you need to do from within the designer and
not using the wizards.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

"Spencer23" <Spencer23@discussions.microsoft.com> wrote in message
news:6AF86F2B-05A4-40CA-A5F2-286D36BDC814@microsoft.com...
> Hi Bruce,
>
> How could multiple datasets be used in the same report?
>
> Thanks
>
> "Spencer23" wrote:
>
> > Hey,
> >
> > Is there any way to use more then one stored procedure, or a stored
> > procedure that returns 2 datatables or 2 datasets in one report, the
same
> > report?
> >
> > Thanks

Spencer23
Mon Jan 17 11:01:04 CST 2005

Thanks Bruce,

I have something else to ask you now then. I am using a chart and I was
wonderig if you know how to insert a line on this chart manually, without
using a field or any data? I made a stored proc that creates several 'total'
values for each year that need to be represented on my chart, but I also need
a 'target' line on my chart which does not correspond to any year, or month.
It is just a target value to compare my proc returned values too. Is there
a way to do this within the chart?

Thanks

"Bruce L-C [MVP]" wrote:

> You can create multiple datasets in the data tab. In layout you can add
> multiple tables and then pick the dataset and add the fields to the table.
> You can only have one dataset with the wizard but when working manually you
> can create as many datasets as you want. Note that a table can only use a
> single dataset, ditto for list, matrix, chart. Also note that you can use
> the same dataset multiple times. For instance I have used a dataset and
> charted it three different ways plus showed the data used. So I had three
> charts and one table on the report, all three used the same dataset but they
> didn't have to, I could have used three different datasets. There are a lot
> of things that can be done that you need to do from within the designer and
> not using the wizards.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Spencer23" <Spencer23@discussions.microsoft.com> wrote in message
> news:6AF86F2B-05A4-40CA-A5F2-286D36BDC814@microsoft.com...
> > Hi Bruce,
> >
> > How could multiple datasets be used in the same report?
> >
> > Thanks
> >
> > "Spencer23" wrote:
> >
> > > Hey,
> > >
> > > Is there any way to use more then one stored procedure, or a stored
> > > procedure that returns 2 datatables or 2 datasets in one report, the
> same
> > > report?
> > >
> > > Thanks
>
>
>

Bruce
Mon Jan 17 11:12:42 CST 2005

I have only done a little bit with charts but I had the same issue and I
added a column to my temp table that I updated with this value. There might
be another way to do this but that is how I solved the problem.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

"Spencer23" <Spencer23@discussions.microsoft.com> wrote in message
news:1BAB97EA-803A-47D0-8107-52F8016166D5@microsoft.com...
> Thanks Bruce,
>
> I have something else to ask you now then. I am using a chart and I was
> wonderig if you know how to insert a line on this chart manually, without
> using a field or any data? I made a stored proc that creates several
'total'
> values for each year that need to be represented on my chart, but I also
need
> a 'target' line on my chart which does not correspond to any year, or
month.
> It is just a target value to compare my proc returned values too. Is
there
> a way to do this within the chart?
>
> Thanks
>
> "Bruce L-C [MVP]" wrote:
>
> > You can create multiple datasets in the data tab. In layout you can add
> > multiple tables and then pick the dataset and add the fields to the
table.
> > You can only have one dataset with the wizard but when working manually
you
> > can create as many datasets as you want. Note that a table can only use
a
> > single dataset, ditto for list, matrix, chart. Also note that you can
use
> > the same dataset multiple times. For instance I have used a dataset and
> > charted it three different ways plus showed the data used. So I had
three
> > charts and one table on the report, all three used the same dataset but
they
> > didn't have to, I could have used three different datasets. There are a
lot
> > of things that can be done that you need to do from within the designer
and
> > not using the wizards.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Spencer23" <Spencer23@discussions.microsoft.com> wrote in message
> > news:6AF86F2B-05A4-40CA-A5F2-286D36BDC814@microsoft.com...
> > > Hi Bruce,
> > >
> > > How could multiple datasets be used in the same report?
> > >
> > > Thanks
> > >
> > > "Spencer23" wrote:
> > >
> > > > Hey,
> > > >
> > > > Is there any way to use more then one stored procedure, or a stored
> > > > procedure that returns 2 datatables or 2 datasets in one report, the
> > same
> > > > report?
> > > >
> > > > Thanks
> >
> >
> >

Spencer23
Mon Jan 17 11:27:04 CST 2005

Ya, I have the same thing done now, but the trouble I am having is that now
for every year in my data I have a 'total' and a 'target' where it just
supposed to be multiple years with totals and just the one target, so my
graph is a mess. The way I have it done is that I have my 'total' and
'target' fields in the "data field" section of the chart, and my 'Year' field
in the "Series field" section of the chart and my 'month' field in the
"Category field" section, this is why each year/month as both a 'target' and
a 'total' and is is messy and not needed. But I am not sure how to keep the
'target' value from refering to a year.

Any suggestions?

"Bruce L-C [MVP]" wrote:

> I have only done a little bit with charts but I had the same issue and I
> added a column to my temp table that I updated with this value. There might
> be another way to do this but that is how I solved the problem.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Spencer23" <Spencer23@discussions.microsoft.com> wrote in message
> news:1BAB97EA-803A-47D0-8107-52F8016166D5@microsoft.com...
> > Thanks Bruce,
> >
> > I have something else to ask you now then. I am using a chart and I was
> > wonderig if you know how to insert a line on this chart manually, without
> > using a field or any data? I made a stored proc that creates several
> 'total'
> > values for each year that need to be represented on my chart, but I also
> need
> > a 'target' line on my chart which does not correspond to any year, or
> month.
> > It is just a target value to compare my proc returned values too. Is
> there
> > a way to do this within the chart?
> >
> > Thanks
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > You can create multiple datasets in the data tab. In layout you can add
> > > multiple tables and then pick the dataset and add the fields to the
> table.
> > > You can only have one dataset with the wizard but when working manually
> you
> > > can create as many datasets as you want. Note that a table can only use
> a
> > > single dataset, ditto for list, matrix, chart. Also note that you can
> use
> > > the same dataset multiple times. For instance I have used a dataset and
> > > charted it three different ways plus showed the data used. So I had
> three
> > > charts and one table on the report, all three used the same dataset but
> they
> > > didn't have to, I could have used three different datasets. There are a
> lot
> > > of things that can be done that you need to do from within the designer
> and
> > > not using the wizards.
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "Spencer23" <Spencer23@discussions.microsoft.com> wrote in message
> > > news:6AF86F2B-05A4-40CA-A5F2-286D36BDC814@microsoft.com...
> > > > Hi Bruce,
> > > >
> > > > How could multiple datasets be used in the same report?
> > > >
> > > > Thanks
> > > >
> > > > "Spencer23" wrote:
> > > >
> > > > > Hey,
> > > > >
> > > > > Is there any way to use more then one stored procedure, or a stored
> > > > > procedure that returns 2 datatables or 2 datasets in one report, the
> > > same
> > > > > report?
> > > > >
> > > > > Thanks
> > >
> > >
> > >
>
>
>

Bruce
Mon Jan 17 12:26:17 CST 2005

Sorry, I'm still a newbie with Charts myself.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

"Spencer23" <Spencer23@discussions.microsoft.com> wrote in message
news:6BD54502-8B38-4D13-85A5-5CC5B3FF6F01@microsoft.com...
> Ya, I have the same thing done now, but the trouble I am having is that
now
> for every year in my data I have a 'total' and a 'target' where it just
> supposed to be multiple years with totals and just the one target, so my
> graph is a mess. The way I have it done is that I have my 'total' and
> 'target' fields in the "data field" section of the chart, and my 'Year'
field
> in the "Series field" section of the chart and my 'month' field in the
> "Category field" section, this is why each year/month as both a 'target'
and
> a 'total' and is is messy and not needed. But I am not sure how to keep
the
> 'target' value from refering to a year.
>
> Any suggestions?
>
> "Bruce L-C [MVP]" wrote:
>
> > I have only done a little bit with charts but I had the same issue and I
> > added a column to my temp table that I updated with this value. There
might
> > be another way to do this but that is how I solved the problem.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Spencer23" <Spencer23@discussions.microsoft.com> wrote in message
> > news:1BAB97EA-803A-47D0-8107-52F8016166D5@microsoft.com...
> > > Thanks Bruce,
> > >
> > > I have something else to ask you now then. I am using a chart and I
was
> > > wonderig if you know how to insert a line on this chart manually,
without
> > > using a field or any data? I made a stored proc that creates several
> > 'total'
> > > values for each year that need to be represented on my chart, but I
also
> > need
> > > a 'target' line on my chart which does not correspond to any year, or
> > month.
> > > It is just a target value to compare my proc returned values too. Is
> > there
> > > a way to do this within the chart?
> > >
> > > Thanks
> > >
> > > "Bruce L-C [MVP]" wrote:
> > >
> > > > You can create multiple datasets in the data tab. In layout you can
add
> > > > multiple tables and then pick the dataset and add the fields to the
> > table.
> > > > You can only have one dataset with the wizard but when working
manually
> > you
> > > > can create as many datasets as you want. Note that a table can only
use
> > a
> > > > single dataset, ditto for list, matrix, chart. Also note that you
can
> > use
> > > > the same dataset multiple times. For instance I have used a dataset
and
> > > > charted it three different ways plus showed the data used. So I had
> > three
> > > > charts and one table on the report, all three used the same dataset
but
> > they
> > > > didn't have to, I could have used three different datasets. There
are a
> > lot
> > > > of things that can be done that you need to do from within the
designer
> > and
> > > > not using the wizards.
> > > >
> > > > --
> > > > Bruce Loehle-Conger
> > > > MVP SQL Server Reporting Services
> > > >
> > > > "Spencer23" <Spencer23@discussions.microsoft.com> wrote in message
> > > > news:6AF86F2B-05A4-40CA-A5F2-286D36BDC814@microsoft.com...
> > > > > Hi Bruce,
> > > > >
> > > > > How could multiple datasets be used in the same report?
> > > > >
> > > > > Thanks
> > > > >
> > > > > "Spencer23" wrote:
> > > > >
> > > > > > Hey,
> > > > > >
> > > > > > Is there any way to use more then one stored procedure, or a
stored
> > > > > > procedure that returns 2 datatables or 2 datasets in one report,
the
> > > > same
> > > > > > report?
> > > > > >
> > > > > > Thanks
> > > >
> > > >
> > > >
> >
> >
> >