Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Jan 28, 2010 06:34 PM by SSMJ
Aug 08, 2007 07:51 PM|LINK
I have a report that is grouped.
Each group section must begin on a new page and I have the report set to put page breaks at end of the groupings. My problem is that a page break is inserted after the last grouping causing the number of pages to increase by one and a blank page with only
the footer on it to display. If I put the page break at start of the group, a blank page prints at the start with only the header and footer, which is worse.
In my search I find that Crystal Reports has a Suppress Blank Pages, but have not found that in Reporting Services.
The only think I can think of is to print the last page without a footer...change the total page to the global number of pages - 1 ...but that is really a work around.
Any help would be appreciated.
Microsoft SQL Server Reporting Services forum
Sep 05, 2007 09:04 PM|LINK
I am having this same problem. I have a page break on a group and a break is inserted after the last grouping causing a blank page at the end of the report. Has anyone recommended a solution.
SSRS Reporting Services
reporting Services multiple reports
page break problem
Sep 11, 2007 10:11 PM|LINK
I had this problem before, but I found out it was the page break problem, it has to be.
You need to check the page break of each table you created, and each cell at the bottom of the page.
If you still can not find it, you have to test on the duplicated report. Make a duplicated copy of the report, then take out one cell or one table, or the group, take out one by one until you know the exact setting that does not cause the blank page.
Sep 26, 2007 06:43 AM|LINK
i have exact same problem. there's a blank page after each group in PDF at print layout mode.
i've can confirm all lists and table have page break at the end unchecked!
what else do you suggest i should try before i go down and delete each table and list.
Sep 26, 2007 10:59 PM|LINK
after i read brian welcker's article on setting page margins:
i set all page margins to zero: topmargin = 0, rightmargin = 0, leftmargin = 0 and bottommargin = 0. and it's now printing without blank page!
Aug 08, 2008 04:19 PM|LINK
Hello to all !
I'm having problems with the print layout, I have a three level report, so I'm using a table which has the first level of information, a subreport inside with the second level and the same for the third level. The thing is, that when I use the print layout
or export it to pdf, the first page shows a couple of lines from the first level and the content of the subreport (level 2) goes to the following page leaving the page #1 almost empty, I really need to print everything as fluent as possible. I already checked
everything that has to do with the page breaks for the grouping settings in the 3 reports, margins and headers, but it keeps doing the same thing... I haven't found any information on the web that help me, so If anybody has an idea of how can I solve this
It would be deeply appreciated.
Thanks in adavance,
Kind regards !
sql 2005 reporting services
Aug 09, 2008 06:02 PM|LINK
You need to look very carefully at the source of the reports. The internal size does not always match the selected paper type. Also there can be a mix-up between metric and imperial sizing.
I have seen your problem. I set a test program where I could easily select the number of lines of total and found that there was a range of total lines whereby there a header on page 1 and detail lines (but no header) on page 2. Allowing more total lines,
gave header and detail on page 1 plus header and some details lines on page 2.
I will try and track down where I reported it.
Aug 09, 2008 06:21 PM|LINK
>I will try and track down where I reported it.
Regrettably I cannot find my earlier report. Had I been able to get permission to release the demo program to Microsoft to illustrate the error, the problem might might be fixed by now.
Aug 09, 2008 07:41 PM|LINK
If I was to set up some demo tables and stored procedure to select a variable number of lines, would you be interested in creating a demo SSRS report to display in the ASP.NET report viewer to select the variable number of total lines?
Aug 18, 2008 04:13 PM|LINK
Sorry it took me so long to answer, in the end I couldn't fix the problem that I was having so I ended up re-designing the report, now it's working fine. I didn't understand exacly what you said about the example you want to do, but if I can help you in
any way just tell me what do you need me to do and I'll help you.
Again, thanks for the help [:)]