Report creates extra page

I have a report that should only generate 2 pages but generates 3.
Group 1 of the report has 41 rows
Group 2 of the report has 52 rows
When the report is generated, Group 1 creates Page 1, Group 2 creates Page 2
"and" Page 3. Page 2 has 46 rows and the remainder of the rows (6) overflow
to page 3.
Is there a limit? Or is there some setting somewhere to control this?
TIAThere is an option under the properties of the table/matrix to "fit on one
page if possible". Also at the top with file, edit, view....there is Report,
then report properties. Under the layout, the length of the page determines
how many objects can fit.
"czac" wrote:
> I have a report that should only generate 2 pages but generates 3.
> Group 1 of the report has 41 rows
> Group 2 of the report has 52 rows
> When the report is generated, Group 1 creates Page 1, Group 2 creates Page 2
> "and" Page 3. Page 2 has 46 rows and the remainder of the rows (6) overflow
> to page 3.
> Is there a limit? Or is there some setting somewhere to control this?
> TIA|||thanks for the reply, scraejtp.
I checked the "fit on one page if possible", this is checked. Also, with
the Layout properties of the Report, Page width: 11in. Page height:8.5in.
(for Landscape printing) Isnt this just for the printing of the report?
thanks again.
"scraejtp" wrote:
> There is an option under the properties of the table/matrix to "fit on one
> page if possible". Also at the top with file, edit, view....there is Report,
> then report properties. Under the layout, the length of the page determines
> how many objects can fit.
> "czac" wrote:
> > I have a report that should only generate 2 pages but generates 3.
> >
> > Group 1 of the report has 41 rows
> > Group 2 of the report has 52 rows
> >
> > When the report is generated, Group 1 creates Page 1, Group 2 creates Page 2
> > "and" Page 3. Page 2 has 46 rows and the remainder of the rows (6) overflow
> > to page 3.
> >
> > Is there a limit? Or is there some setting somewhere to control this?
> >
> > TIA|||No, if you change that length it will also change how much can fit on a page.
"czac" wrote:
> thanks for the reply, scraejtp.
> I checked the "fit on one page if possible", this is checked. Also, with
> the Layout properties of the Report, Page width: 11in. Page height:8.5in.
> (for Landscape printing) Isnt this just for the printing of the report?
> thanks again.
>
> "scraejtp" wrote:
> > There is an option under the properties of the table/matrix to "fit on one
> > page if possible". Also at the top with file, edit, view....there is Report,
> > then report properties. Under the layout, the length of the page determines
> > how many objects can fit.
> >
> > "czac" wrote:
> >
> > > I have a report that should only generate 2 pages but generates 3.
> > >
> > > Group 1 of the report has 41 rows
> > > Group 2 of the report has 52 rows
> > >
> > > When the report is generated, Group 1 creates Page 1, Group 2 creates Page 2
> > > "and" Page 3. Page 2 has 46 rows and the remainder of the rows (6) overflow
> > > to page 3.
> > >
> > > Is there a limit? Or is there some setting somewhere to control this?
> > >
> > > TIA|||...well...I changed the Page Height to 11in., that fixed the page 3 issue
but created a problem with printing landscape. Any ideas where to go from
here?
thanks.
"scraejtp" wrote:
> No, if you change that length it will also change how much can fit on a page.
> "czac" wrote:
> > thanks for the reply, scraejtp.
> >
> > I checked the "fit on one page if possible", this is checked. Also, with
> > the Layout properties of the Report, Page width: 11in. Page height:8.5in.
> > (for Landscape printing) Isnt this just for the printing of the report?
> >
> > thanks again.
> >
> >
> > "scraejtp" wrote:
> >
> > > There is an option under the properties of the table/matrix to "fit on one
> > > page if possible". Also at the top with file, edit, view....there is Report,
> > > then report properties. Under the layout, the length of the page determines
> > > how many objects can fit.
> > >
> > > "czac" wrote:
> > >
> > > > I have a report that should only generate 2 pages but generates 3.
> > > >
> > > > Group 1 of the report has 41 rows
> > > > Group 2 of the report has 52 rows
> > > >
> > > > When the report is generated, Group 1 creates Page 1, Group 2 creates Page 2
> > > > "and" Page 3. Page 2 has 46 rows and the remainder of the rows (6) overflow
> > > > to page 3.
> > > >
> > > > Is there a limit? Or is there some setting somewhere to control this?
> > > >
> > > > TIA|||Yes, I said it would also change the landscape. I don't see how else you want
it to fit. It will have to be longer to fit on the page, or make the typing
smaller to fit everything on the same size page. You could try keeping the
page size the same and making the margins less to fit a little more
information on the page.
"czac" wrote:
> ...well...I changed the Page Height to 11in., that fixed the page 3 issue
> but created a problem with printing landscape. Any ideas where to go from
> here?
> thanks.
> "scraejtp" wrote:
> > No, if you change that length it will also change how much can fit on a page.
> >
> > "czac" wrote:
> >
> > > thanks for the reply, scraejtp.
> > >
> > > I checked the "fit on one page if possible", this is checked. Also, with
> > > the Layout properties of the Report, Page width: 11in. Page height:8.5in.
> > > (for Landscape printing) Isnt this just for the printing of the report?
> > >
> > > thanks again.
> > >
> > >
> > > "scraejtp" wrote:
> > >
> > > > There is an option under the properties of the table/matrix to "fit on one
> > > > page if possible". Also at the top with file, edit, view....there is Report,
> > > > then report properties. Under the layout, the length of the page determines
> > > > how many objects can fit.
> > > >
> > > > "czac" wrote:
> > > >
> > > > > I have a report that should only generate 2 pages but generates 3.
> > > > >
> > > > > Group 1 of the report has 41 rows
> > > > > Group 2 of the report has 52 rows
> > > > >
> > > > > When the report is generated, Group 1 creates Page 1, Group 2 creates Page 2
> > > > > "and" Page 3. Page 2 has 46 rows and the remainder of the rows (6) overflow
> > > > > to page 3.
> > > > >
> > > > > Is there a limit? Or is there some setting somewhere to control this?
> > > > >
> > > > > TIA|||I have also had problem w/ xtra page. Sometimes it was due to a textbox
object in the header of my report. The textbox would 'hang' on the margin and
would force and extra page. Adjusting the size and or placement of header
items seemed to fix it. (also footer)
--
U. Tokklas
"scraejtp" wrote:
> Yes, I said it would also change the landscape. I don't see how else you want
> it to fit. It will have to be longer to fit on the page, or make the typing
> smaller to fit everything on the same size page. You could try keeping the
> page size the same and making the margins less to fit a little more
> information on the page.
> "czac" wrote:
> > ...well...I changed the Page Height to 11in., that fixed the page 3 issue
> > but created a problem with printing landscape. Any ideas where to go from
> > here?
> >
> > thanks.
> >
> > "scraejtp" wrote:
> >
> > > No, if you change that length it will also change how much can fit on a page.
> > >
> > > "czac" wrote:
> > >
> > > > thanks for the reply, scraejtp.
> > > >
> > > > I checked the "fit on one page if possible", this is checked. Also, with
> > > > the Layout properties of the Report, Page width: 11in. Page height:8.5in.
> > > > (for Landscape printing) Isnt this just for the printing of the report?
> > > >
> > > > thanks again.
> > > >
> > > >
> > > > "scraejtp" wrote:
> > > >
> > > > > There is an option under the properties of the table/matrix to "fit on one
> > > > > page if possible". Also at the top with file, edit, view....there is Report,
> > > > > then report properties. Under the layout, the length of the page determines
> > > > > how many objects can fit.
> > > > >
> > > > > "czac" wrote:
> > > > >
> > > > > > I have a report that should only generate 2 pages but generates 3.
> > > > > >
> > > > > > Group 1 of the report has 41 rows
> > > > > > Group 2 of the report has 52 rows
> > > > > >
> > > > > > When the report is generated, Group 1 creates Page 1, Group 2 creates Page 2
> > > > > > "and" Page 3. Page 2 has 46 rows and the remainder of the rows (6) overflow
> > > > > > to page 3.
> > > > > >
> > > > > > Is there a limit? Or is there some setting somewhere to control this?
> > > > > >
> > > > > > TIA|||I too had this problem (RS2005) - it is hugely frustrating. The solution for me turned out to be related to the width of my sub reports. To fix it, I had to play with the page width and margins in each of the sub reports (I set the margins to zero in parent and sub reports).
It seemed to be that my sub report changes would not show up when previewing the main report. Once I had saved and previewed the sub reports, then clicked the refresh button when previewing the parent report, the changes finally showed up and the extra page went away... hooray!
Good luck with this nasty proble
From http://www.developmentnow.com/g/115_2005_7_0_0_565515/Report-creates-extra-page.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com