| Groups | Blog | Home |
sql server reporting services : Report creates extra page
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?
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. [quoted text, click to view] "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? >
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. [quoted text, click to view] "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? > >
No, if you change that length it will also change how much can fit on a page.
[quoted text, click to view] "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? > > >
.....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. [quoted text, click to view] "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? > > > >
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. [quoted text, click to view] "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? > > > > >
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 [quoted text, click to view] "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? > > > > > >
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 problem From http://www.developmentnow.com/g/115_2005_7_0_0_565515/Report-creates-extra-page.htm Posted via DevelopmentNow.com Groups
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |