Showing posts with label returned. Show all posts
Showing posts with label returned. Show all posts

Thursday, February 16, 2012

cannot see the 2nd table(2 tables returned from stored procedure) in dataset in report designer

Hi,

I am using stored procedure(SP) to create the dataset in report designer. My SP is returning 2 tables/recordset and i am only able to see first table/recordset in the dataset in report designer. I have to place fields from second table onto my report. Is there anyway i could get the 2nd table in my dataset so that i could place the fields in my report.

Please help

This is by design. We'll only look at the first resultset.

You create a second sproc to return the second resultset and build a second dataset to consume it.

|||

Hi

I am also facing the same problem. Could you help how to write a stored procedure to retrieve the second table from stored procedure. So that I will create second dataset as you said.

Thanks & Regards

Kumar

cannot see the 2nd table(2 tables returned from stored procedure) in dataset in report designer

Hi,

I am using stored procedure(SP) to create the dataset in report designer. My SP is returning 2 tables/recordset and i am only able to see first table/recordset in the dataset in report designer. I have to place fields from second table onto my report. Is there anyway i could get the 2nd table in my dataset so that i could place the fields in my report.

Please help

This is by design. We'll only look at the first resultset.

You create a second sproc to return the second resultset and build a second dataset to consume it.

|||

Hi

I am also facing the same problem. Could you help how to write a stored procedure to retrieve the second table from stored procedure. So that I will create second dataset as you said.

Thanks & Regards

Kumar

Tuesday, February 14, 2012

Cannot see all records in report

Ok..
On the data tab I can see 6 rows of data returned from a sproc
When I input these same parameters onto the report (preview) I can only see
the first or last record depending on the following:
=First(Fields!Year.Value) - gives me first
=(Fields!Year.Value) - also gives me first (I thought this would give me all
values)
=Last(Fields!Year.Value) - gives me last
I just threw the field on the report inside a rectangle which I have set to
put a page break after.
For simplicity, assume I only have to print the year on each page.. how do I
do that? At the moment, I can only print 1.
Tx
LesYou need to put a list control or a table control. What you are doing will
only show one record.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"LesWright" <LesWright@.discussions.microsoft.com> wrote in message
news:E584CC12-08AA-4B5E-8CC8-BEA8291A2D97@.microsoft.com...
> Ok..
> On the data tab I can see 6 rows of data returned from a sproc
> When I input these same parameters onto the report (preview) I can only
> see
> the first or last record depending on the following:
> =First(Fields!Year.Value) - gives me first
> =(Fields!Year.Value) - also gives me first (I thought this would give me
> all
> values)
> =Last(Fields!Year.Value) - gives me last
> I just threw the field on the report inside a rectangle which I have set
> to
> put a page break after.
> For simplicity, assume I only have to print the year on each page.. how do
> I
> do that? At the moment, I can only print 1.
> Tx
> Les|||Thanks Bruce for your reply.
To confirm, you're saying that if I want the information pertaining to one
record to occupy 1 page, I need to add a list or table and design that to
occupy one page, with a page break for the next record?
Tx
Les
"Bruce L-C [MVP]" wrote:
> You need to put a list control or a table control. What you are doing will
> only show one record.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "LesWright" <LesWright@.discussions.microsoft.com> wrote in message
> news:E584CC12-08AA-4B5E-8CC8-BEA8291A2D97@.microsoft.com...
> > Ok..
> > On the data tab I can see 6 rows of data returned from a sproc
> > When I input these same parameters onto the report (preview) I can only
> > see
> > the first or last record depending on the following:
> >
> > =First(Fields!Year.Value) - gives me first
> > =(Fields!Year.Value) - also gives me first (I thought this would give me
> > all
> > values)
> > =Last(Fields!Year.Value) - gives me last
> >
> > I just threw the field on the report inside a rectangle which I have set
> > to
> > put a page break after.
> >
> > For simplicity, assume I only have to print the year on each page.. how do
> > I
> > do that? At the moment, I can only print 1.
> >
> > Tx
> > Les
>
>|||If you want one record per page then you want to have a list, have a group
with a page break to force one record per page.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"LesWright" <LesWright@.discussions.microsoft.com> wrote in message
news:96A788F1-337C-4712-8094-2DA68FC192F7@.microsoft.com...
> Thanks Bruce for your reply.
> To confirm, you're saying that if I want the information pertaining to one
> record to occupy 1 page, I need to add a list or table and design that to
> occupy one page, with a page break for the next record?
> Tx
> Les
> "Bruce L-C [MVP]" wrote:
>> You need to put a list control or a table control. What you are doing
>> will
>> only show one record.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "LesWright" <LesWright@.discussions.microsoft.com> wrote in message
>> news:E584CC12-08AA-4B5E-8CC8-BEA8291A2D97@.microsoft.com...
>> > Ok..
>> > On the data tab I can see 6 rows of data returned from a sproc
>> > When I input these same parameters onto the report (preview) I can only
>> > see
>> > the first or last record depending on the following:
>> >
>> > =First(Fields!Year.Value) - gives me first
>> > =(Fields!Year.Value) - also gives me first (I thought this would give
>> > me
>> > all
>> > values)
>> > =Last(Fields!Year.Value) - gives me last
>> >
>> > I just threw the field on the report inside a rectangle which I have
>> > set
>> > to
>> > put a page break after.
>> >
>> > For simplicity, assume I only have to print the year on each page.. how
>> > do
>> > I
>> > do that? At the moment, I can only print 1.
>> >
>> > Tx
>> > Les
>>|||Thanks Bruce.
Les
"Bruce L-C [MVP]" wrote:
> If you want one record per page then you want to have a list, have a group
> with a page break to force one record per page.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "LesWright" <LesWright@.discussions.microsoft.com> wrote in message
> news:96A788F1-337C-4712-8094-2DA68FC192F7@.microsoft.com...
> > Thanks Bruce for your reply.
> >
> > To confirm, you're saying that if I want the information pertaining to one
> > record to occupy 1 page, I need to add a list or table and design that to
> > occupy one page, with a page break for the next record?
> >
> > Tx
> > Les
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> You need to put a list control or a table control. What you are doing
> >> will
> >> only show one record.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "LesWright" <LesWright@.discussions.microsoft.com> wrote in message
> >> news:E584CC12-08AA-4B5E-8CC8-BEA8291A2D97@.microsoft.com...
> >> > Ok..
> >> > On the data tab I can see 6 rows of data returned from a sproc
> >> > When I input these same parameters onto the report (preview) I can only
> >> > see
> >> > the first or last record depending on the following:
> >> >
> >> > =First(Fields!Year.Value) - gives me first
> >> > =(Fields!Year.Value) - also gives me first (I thought this would give
> >> > me
> >> > all
> >> > values)
> >> > =Last(Fields!Year.Value) - gives me last
> >> >
> >> > I just threw the field on the report inside a rectangle which I have
> >> > set
> >> > to
> >> > put a page break after.
> >> >
> >> > For simplicity, assume I only have to print the year on each page.. how
> >> > do
> >> > I
> >> > do that? At the moment, I can only print 1.
> >> >
> >> > Tx
> >> > Les
> >>
> >>
> >>
>
>