Blank space between Details section and Page Footer section.

hey folks,
this is probably a newbe question, but please bear with me. so here is the deal i have this report and i have one grouping in it and then i've suppressed the Report Footer and have some stuff in the Page Footer. Here is a picture to illustrate this (i'll continue the question in my next post):So the problem is that when i Preview the report, it gives me blank space between my Details section and the Page Footer. Here is a picture of the problem. Can anyone explain this to me?

Thanks.|||Suppress GroupFooter1 if there's nothing in it.|||it's already suppressed.
Also, none of my sections has the Keep Together, No Page After, or Print At Bottom Of Page options checked.

Both Group Header #1 and Report Footer are hidden and suppressed.

And I still get the blank space.|||Hi,

May be a silly answer. But your report is displaying normal. Your report data is finished within the page (for ex half of the page). Your picture is displaying at the Page Footer. So the remaining space remains as blank.

Actually what do you want to do?|||O, so what you are saying is that the PageFooter always displays at the bottom of the page no matter what?

I knew it was a newbie question.

What i wanted was for the stuff in the Page Footer to display directly below the last record in the Details section, but i guess a Page Footer won't work for that.|||Yes, Hope you got it.

In your case, you can display the object (or anything) in the Report Footer area so that it will display right after the report. But it will display only at the end of the page not in all pages.

To display in all pages, you can use page footer and use some formula to restrict the display it is last page.
Ex.

Right Click your picture : Select Format Graphic option. Check Suppress and then click X-2 button. Select PageNumber and TotalPagecount from the PrintState functions list/enter the following

PageNumber = TotalPageCount

Click Ok.

Note. Place the picture in Page Footer as well as in Report Footer so that you can get the picture in all the pages except the last page and at the end of the report|||harmonycitra,
now you are confusing me. Maybe I am missunderstanding you about the Page Footer; in your first post you said that in case the report data is finished withing the page (for ex half the page) than having blank space between the Details and Page Footer sections is normal. Now, in your last post, you said that if i wanted to print something on each page right after the Details section, i can use the Page Footer. Please understand that by "right after the Details section" I mean no blank space between the Details section and the section that comes right below it, hence I can not use the Page Footer for that purpose since if I do a blank space would show up on the report if the data in Details has finished within the half of the page. Do you see the contradiction here or I am just not understanding what exactly is it that you were saying earlier?|||Sorry for the confusion.

Normally Page Footer will display at the bottom of each and every page. If a report contains 3 pages, the first two pages will be filled fully. The third page i,e the last page may not having the data to fill the entire page. In that case there will be a blank space appear between the Details and the Page Footer.
This is not because of page footer but because of detail section is finished half of the third page.

But the Report Footer will display at the end of the report. (always in the last page)

In your example which you had posted, try to put the totals in the report footer and finish the boxes, lines in Report Footer. It'll work fine.

Hope you understand. Otherwise I'll send some sample|||yes, i understand. i'd actually already put the summary lines, etc. in the Report Footer and it works fine, i just wanted to clear this up for myself. you learn something new every day i guess.

thanks for your help.

Blank pages in report preview

Hello, Everyone,

I'm new to Reporting Services. I wrote a report today containing one grouping. Everything appears all right in the report preview, except that every other page is "blank", i.e., shows only the page header and page footer; all grouping and detail information is missing. The data on the page following the blank page seems to pick up where the previous non-blank page left off, so all information seems to be present within the report.

The report width and height properties are typical portrait-style -- 8.5 x 11 inches. The columns do not "run off the edge" of the report page boundary. I haven't selected any page break for the grouping, as the grouping detail is typically only a few rows long, and would otherwise result in a very large number of pages. Can anyone offer some advice to correct this problem, please?

Many thanks!

CraigI found the problem cause. In Reporting Services,

report body width must be <= (report width - report margins width).

I reduced the margins to zero width, and the pagination problem disappeared!|||

Hi,

I am struggeling with the same problem, only your solution does not work for me...

My page width = 30cm, Report Width = 26cm, Margins = 1 cm allround, and no fields are set to CanGrow=false, any other ideas?

I'm using RS 2000

|||I have just upgraded the report to RS 2005 without any modifications, and the problem disappeared, seems to be a RS 2000 bug...|||

Hi,

I'm having the same problem but with a twist.

If the body width <= report width+margins then i only get 1 page of the report with no blank pages. (supposed to be 2)

If however the body width > report width+margins then i get all the pages but with an extra 2 blank pages.

Any ideas anyone? (I'm using RS2005)

|||

Craig,

Thanks! That one had me. All I had to do was right-click on the "Body" section and set the width to 10in and it worked fine.

Jim

|||Had another similar problem, this time involving a matrix Table (cross-tab) in the Body section of the report. I had to actually make the Table itself smaller (narrower) until the blank page disappeared in Preview. Also, I noticed that in Preview the blank pages didn't show up until I clicked the Print Layout button on the toolbar in Preview. Similar problems happen in Reporting Services report viewer. Weird.|||

I am using a matrix control in a report containing 2 subreports. The matrix control is present in one of the subreports. When I export the full report into the PDF,if the matrix are rendered in a single page, the report is fine and there are no blank pages. But when the number of columns exceeds the first page and moves into the second page then there are 3 blank pages in the report for every page with content.

This problem occurs only when I try to generate the whole report. No blank pages appear when I render subreports into PDFs individually.

Please help!!

Cheers!!

Ravi

Blank pages in report preview

Hello, Everyone,

I'm new to Reporting Services. I wrote a report today containing one grouping. Everything appears all right in the report preview, except that every other page is "blank", i.e., shows only the page header and page footer; all grouping and detail information is missing. The data on the page following the blank page seems to pick up where the previous non-blank page left off, so all information seems to be present within the report.

The report width and height properties are typical portrait-style -- 8.5 x 11 inches. The columns do not "run off the edge" of the report page boundary. I haven't selected any page break for the grouping, as the grouping detail is typically only a few rows long, and would otherwise result in a very large number of pages. Can anyone offer some advice to correct this problem, please?

Many thanks!

CraigI found the problem cause. In Reporting Services,

report body width must be <= (report width - report margins width).

I reduced the margins to zero width, and the pagination problem disappeared!|||

Hi,

I am struggeling with the same problem, only your solution does not work for me...

My page width = 30cm, Report Width = 26cm, Margins = 1 cm allround, and no fields are set to CanGrow=false, any other ideas?

I'm using RS 2000

|||I have just upgraded the report to RS 2005 without any modifications, and the problem disappeared, seems to be a RS 2000 bug...|||

Hi,

I'm having the same problem but with a twist.

If the body width <= report width+margins then i only get 1 page of the report with no blank pages. (supposed to be 2)

If however the body width > report width+margins then i get all the pages but with an extra 2 blank pages.

Any ideas anyone? (I'm using RS2005)

|||

Craig,

Thanks! That one had me. All I had to do was right-click on the "Body" section and set the width to 10in and it worked fine.

Jim

|||Had another similar problem, this time involving a matrix Table (cross-tab) in the Body section of the report. I had to actually make the Table itself smaller (narrower) until the blank page disappeared in Preview. Also, I noticed that in Preview the blank pages didn't show up until I clicked the Print Layout button on the toolbar in Preview. Similar problems happen in Reporting Services report viewer. Weird.|||

I am using a matrix control in a report containing 2 subreports. The matrix control is present in one of the subreports. When I export the full report into the PDF,if the matrix are rendered in a single page, the report is fine and there are no blank pages. But when the number of columns exceeds the first page and moves into the second page then there are 3 blank pages in the report for every page with content.

This problem occurs only when I try to generate the whole report. No blank pages appear when I render subreports into PDFs individually.

Please help!!

Cheers!!

Ravi

Blank pages in report preview

Hello, Everyone,

I'm new to Reporting Services. I wrote a report today containing one grouping. Everything appears all right in the report preview, except that every other page is "blank", i.e., shows only the page header and page footer; all grouping and detail information is missing. The data on the page following the blank page seems to pick up where the previous non-blank page left off, so all information seems to be present within the report.

The report width and height properties are typical portrait-style -- 8.5 x 11 inches. The columns do not "run off the edge" of the report page boundary. I haven't selected any page break for the grouping, as the grouping detail is typically only a few rows long, and would otherwise result in a very large number of pages. Can anyone offer some advice to correct this problem, please?

Many thanks!

CraigI found the problem cause. In Reporting Services,

report body width must be <= (report width - report margins width).

I reduced the margins to zero width, and the pagination problem disappeared!|||

Hi,

I am struggeling with the same problem, only your solution does not work for me...

My page width = 30cm, Report Width = 26cm, Margins = 1 cm allround, and no fields are set to CanGrow=false, any other ideas?

I'm using RS 2000

|||I have just upgraded the report to RS 2005 without any modifications, and the problem disappeared, seems to be a RS 2000 bug...|||

Hi,

I'm having the same problem but with a twist.

If the body width <= report width+margins then i only get 1 page of the report with no blank pages. (supposed to be 2)

If however the body width > report width+margins then i get all the pages but with an extra 2 blank pages.

Any ideas anyone? (I'm using RS2005)

|||

Craig,

Thanks! That one had me. All I had to do was right-click on the "Body" section and set the width to 10in and it worked fine.

Jim

|||Had another similar problem, this time involving a matrix Table (cross-tab) in the Body section of the report. I had to actually make the Table itself smaller (narrower) until the blank page disappeared in Preview. Also, I noticed that in Preview the blank pages didn't show up until I clicked the Print Layout button on the toolbar in Preview. Similar problems happen in Reporting Services report viewer. Weird.|||

I am using a matrix control in a report containing 2 subreports. The matrix control is present in one of the subreports. When I export the full report into the PDF,if the matrix are rendered in a single page, the report is fine and there are no blank pages. But when the number of columns exceeds the first page and moves into the second page then there are 3 blank pages in the report for every page with content.

This problem occurs only when I try to generate the whole report. No blank pages appear when I render subreports into PDFs individually.

Please help!!

Cheers!!

Ravi

Blank pages in report preview

Hello, Everyone,

I'm new to Reporting Services. I wrote a report today containing one grouping. Everything appears all right in the report preview, except that every other page is "blank", i.e., shows only the page header and page footer; all grouping and detail information is missing. The data on the page following the blank page seems to pick up where the previous non-blank page left off, so all information seems to be present within the report.

The report width and height properties are typical portrait-style -- 8.5 x 11 inches. The columns do not "run off the edge" of the report page boundary. I haven't selected any page break for the grouping, as the grouping detail is typically only a few rows long, and would otherwise result in a very large number of pages. Can anyone offer some advice to correct this problem, please?

Many thanks!

CraigI found the problem cause. In Reporting Services,

report body width must be <= (report width - report margins width).

I reduced the margins to zero width, and the pagination problem disappeared!|||

Hi,

I am struggeling with the same problem, only your solution does not work for me...

My page width = 30cm, Report Width = 26cm, Margins = 1 cm allround, and no fields are set to CanGrow=false, any other ideas?

I'm using RS 2000

|||I have just upgraded the report to RS 2005 without any modifications, and the problem disappeared, seems to be a RS 2000 bug...|||

Hi,

I'm having the same problem but with a twist.

If the body width <= report width+margins then i only get 1 page of the report with no blank pages. (supposed to be 2)

If however the body width > report width+margins then i get all the pages but with an extra 2 blank pages.

Any ideas anyone? (I'm using RS2005)

|||

Craig,

Thanks! That one had me. All I had to do was right-click on the "Body" section and set the width to 10in and it worked fine.

Jim

|||Had another similar problem, this time involving a matrix Table (cross-tab) in the Body section of the report. I had to actually make the Table itself smaller (narrower) until the blank page disappeared in Preview. Also, I noticed that in Preview the blank pages didn't show up until I clicked the Print Layout button on the toolbar in Preview. Similar problems happen in Reporting Services report viewer. Weird.|||

I am using a matrix control in a report containing 2 subreports. The matrix control is present in one of the subreports. When I export the full report into the PDF,if the matrix are rendered in a single page, the report is fine and there are no blank pages. But when the number of columns exceeds the first page and moves into the second page then there are 3 blank pages in the report for every page with content.

This problem occurs only when I try to generate the whole report. No blank pages appear when I render subreports into PDFs individually.

Please help!!

Cheers!!

Ravi

Blank pages in report preview

Hello, Everyone,

I'm new to Reporting Services. I wrote a report today containing one grouping. Everything appears all right in the report preview, except that every other page is "blank", i.e., shows only the page header and page footer; all grouping and detail information is missing. The data on the page following the blank page seems to pick up where the previous non-blank page left off, so all information seems to be present within the report.

The report width and height properties are typical portrait-style -- 8.5 x 11 inches. The columns do not "run off the edge" of the report page boundary. I haven't selected any page break for the grouping, as the grouping detail is typically only a few rows long, and would otherwise result in a very large number of pages. Can anyone offer some advice to correct this problem, please?

Many thanks!

CraigI found the problem cause. In Reporting Services,

report body width must be <= (report width - report margins width).

I reduced the margins to zero width, and the pagination problem disappeared!|||

Hi,

I am struggeling with the same problem, only your solution does not work for me...

My page width = 30cm, Report Width = 26cm, Margins = 1 cm allround, and no fields are set to CanGrow=false, any other ideas?

I'm using RS 2000

|||I have just upgraded the report to RS 2005 without any modifications, and the problem disappeared, seems to be a RS 2000 bug...|||

Hi,

I'm having the same problem but with a twist.

If the body width <= report width+margins then i only get 1 page of the report with no blank pages. (supposed to be 2)

If however the body width > report width+margins then i get all the pages but with an extra 2 blank pages.

Any ideas anyone? (I'm using RS2005)

|||

Craig,

Thanks! That one had me. All I had to do was right-click on the "Body" section and set the width to 10in and it worked fine.

Jim

|||Had another similar problem, this time involving a matrix Table (cross-tab) in the Body section of the report. I had to actually make the Table itself smaller (narrower) until the blank page disappeared in Preview. Also, I noticed that in Preview the blank pages didn't show up until I clicked the Print Layout button on the toolbar in Preview. Similar problems happen in Reporting Services report viewer. Weird.|||

I am using a matrix control in a report containing 2 subreports. The matrix control is present in one of the subreports. When I export the full report into the PDF,if the matrix are rendered in a single page, the report is fine and there are no blank pages. But when the number of columns exceeds the first page and moves into the second page then there are 3 blank pages in the report for every page with content.

This problem occurs only when I try to generate the whole report. No blank pages appear when I render subreports into PDFs individually.

Please help!!

Cheers!!

Ravi