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.
Thanks,
Reporting ServicesReportViewerPDFMicrosoft SQL Server Reporting Services forum
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.
Reporting ServicesSSRS Reporting Servicesreporting Services multiple reportspage break problem
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.
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.
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.
Click "Mark as Answer" on the post that helped you.
This earns you a point and marks your thread as Resolved so we will all know you have been helped.
FAQ on the correct forum http://forums.asp.net/p/1337412/2699239.aspx#2699239
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.
Click "Mark as Answer" on the post that helped you.
This earns you a point and marks your thread as Resolved so we will all know you have been helped.
FAQ on the correct forum http://forums.asp.net/p/1337412/2699239.aspx#2699239
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?
Click "Mark as Answer" on the post that helped you.
This earns you a point and marks your thread as Resolved so we will all know you have been helped.
FAQ on the correct forum http://forums.asp.net/p/1337412/2699239.aspx#2699239
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.
ragtop
0 Points
1 Post
SQL 2005 Reporting Services...blank page at end in PDF and Print Layout mode
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.
Thanks,
Reporting Services ReportViewer PDF Microsoft SQL Server Reporting Services forum
DLBen2
Member
2 Points
1 Post
Re: SQL 2005 Reporting Services...blank page at end in PDF and Print Layout mode
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.
Reporting Services SSRS Reporting Services reporting Services multiple reports page break problem
Fulankazu
Member
8 Points
4 Posts
Re: SQL 2005 Reporting Services...blank page at end in PDF and Print Layout mode
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.
tnafoo
Member
19 Points
16 Posts
Re: SQL 2005 Reporting Services...blank page at end in PDF and Print Layout mode
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.
tnafoo
Member
19 Points
16 Posts
Re: SQL 2005 Reporting Services...blank page at end in PDF and Print Layout mode
Sep 26, 2007 10:59 PM|LINK
after i read brian welcker's article on setting page margins:
http://blogs.msdn.com/bwelcker/archive/2005/08/19/Alien-Lanes-_2800_Logical-and-Physical-Pagination-Rules_2900_.aspx
i set all page margins to zero: topmargin = 0, rightmargin = 0, leftmargin = 0 and bottommargin = 0. and it's now printing without blank page!
joanecita
Member
4 Points
2 Posts
SQL 2005 Reporting Services... Problems with the PDF and Print Layout mode
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 !
-- Joa
sql 2005 reporting services
TATWORTH
All-Star
72405 Points
14018 Posts
MVP
Re: SQL 2005 Reporting Services... Problems with the PDF and Print Layout mode
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.
This earns you a point and marks your thread as Resolved so we will all know you have been helped.
FAQ on the correct forum http://forums.asp.net/p/1337412/2699239.aspx#2699239
TATWORTH
All-Star
72405 Points
14018 Posts
MVP
Re: SQL 2005 Reporting Services... Problems with the PDF and Print Layout mode
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.
This earns you a point and marks your thread as Resolved so we will all know you have been helped.
FAQ on the correct forum http://forums.asp.net/p/1337412/2699239.aspx#2699239
TATWORTH
All-Star
72405 Points
14018 Posts
MVP
Re: SQL 2005 Reporting Services... Problems with the PDF and Print Layout mode
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?
This earns you a point and marks your thread as Resolved so we will all know you have been helped.
FAQ on the correct forum http://forums.asp.net/p/1337412/2699239.aspx#2699239
joanecita
Member
4 Points
2 Posts
Re: SQL 2005 Reporting Services... Problems with the PDF and Print Layout mode
Aug 18, 2008 04:13 PM|LINK
Hello,
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 [:)]
Greetings !
--
Joan