Showing posts with label sproc. Show all posts
Showing posts with label sproc. Show all posts

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
> >>
> >>
> >>
>
>