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