Pagination Control

Hi Ppl
I have alot of headache with pagination control on reporting services. Is
there a way to control how many groups/items/rows in one page?
Is there a way to show all items on 1 big page, instead of paging them? I've
try to set the report hieght, but that doesn't help at all.
If pagination must happen, then is there a way to search through all pages
for a perticular string?
Lastly is there a way to stop a group being seperated into 2 pages, (I know
you can have 1 group per page, but thats not what i want). The height of the
group are dynamic, so i can adjust the height group with the report size to
make them not break.See Inline
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"gMaster" <gMaster@.discussions.microsoft.com> wrote in message
news:8EBFCE2B-F794-4550-AB86-FB3F6058A0AA@.microsoft.com...
> Hi Ppl
> I have alot of headache with pagination control on reporting services. Is
> there a way to control how many groups/items/rows in one page?
I have placed 2 examples in the downloads section for reporting services->
RDL on
http:://www.msbicentral.com
They are called PagedTableParameters (This uses a Parameter to allow dynamic
selection of the number of rows which should be placed on a page... nice...
uses Northwind.) and PageBreakSample.RDL (For Beginners, take a look at the
page breaks on each grouping. Uses the Northwind Data Source.)
> Is there a way to show all items on 1 big page, instead of paging them?
I've
> try to set the report hieght, but that doesn't help at all.
Simply do not turn on page breaks for the groups, etc... IN html you will
get one long page. when you export to PDF however you will get pages (
because you will print on to actual paper.)
> If pagination must happen, then is there a way to search through all pages
> for a perticular string?
IN html there is a Find textbox at the top with the parameters after you run
a report, simply type in the text you wish to find...
> Lastly is there a way to stop a group being seperated into 2 pages, (I
know
> you can have 1 group per page, but thats not what i want). The height of
the
> group are dynamic, so i can adjust the height group with the report size
to
> make them not break.
There is a group property called Keeptogether( I tink that is the name) turn
this property on...|||Hi,
I kinda have the same prob. I also want everything on one page. There's no
grouping / page breaking or whatever in my rdl. I Have 1 table with +/- 500
rows, and i want them all on one page. I do use the reportviewer control, so
on top, you can see "page x of x". Perhaps it's a setting there ?
Thanks
"Wayne Snyder" wrote:
> See Inline
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "gMaster" <gMaster@.discussions.microsoft.com> wrote in message
> news:8EBFCE2B-F794-4550-AB86-FB3F6058A0AA@.microsoft.com...
> > Hi Ppl
> > I have alot of headache with pagination control on reporting services. Is
> > there a way to control how many groups/items/rows in one page?
> I have placed 2 examples in the downloads section for reporting services->
> RDL on
> http:://www.msbicentral.com
> They are called PagedTableParameters (This uses a Parameter to allow dynamic
> selection of the number of rows which should be placed on a page... nice...
> uses Northwind.) and PageBreakSample.RDL (For Beginners, take a look at the
> page breaks on each grouping. Uses the Northwind Data Source.)
>
> > Is there a way to show all items on 1 big page, instead of paging them?
> I've
> > try to set the report hieght, but that doesn't help at all.
> Simply do not turn on page breaks for the groups, etc... IN html you will
> get one long page. when you export to PDF however you will get pages (
> because you will print on to actual paper.)
> >
> > If pagination must happen, then is there a way to search through all pages
> > for a perticular string?
> IN html there is a Find textbox at the top with the parameters after you run
> a report, simply type in the text you wish to find...
> >
> > Lastly is there a way to stop a group being seperated into 2 pages, (I
> know
> > you can have 1 group per page, but thats not what i want). The height of
> the
> > group are dynamic, so i can adjust the height group with the report size
> to
> > make them not break.
> There is a group property called Keeptogether( I tink that is the name) turn
> this property on...
>
>