SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Blank pages in print preview and pdf format view


Blank pages in print preview and pdf format view

Author
Message
ajashadi
ajashadi
SSC Veteran
SSC Veteran (237 reputation)SSC Veteran (237 reputation)SSC Veteran (237 reputation)SSC Veteran (237 reputation)SSC Veteran (237 reputation)SSC Veteran (237 reputation)SSC Veteran (237 reputation)SSC Veteran (237 reputation)

Group: General Forum Members
Points: 237 Visits: 40
Hi,
I have developed some reports and when I export it pdf format or look at print preview, I can see some blank pages added to the report. Here are the scenarios :
1) there is a report of 1 page only, but when I see print preview it says 2 pages and second page is empty.
2) I had a 2 page report, with 2 tables side by side. now the result from one of the columns in second table is bit long and this results in 2 page report. When I print preview or export to pdf this report, the first page has data followed by empty page followed by some data and finally followed by empty page again. I dont know why this is happening.

Any suggestions are welcome.

Kerrie Sorrell
Kerrie Sorrell
SSC-Enthusiastic
SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)

Group: General Forum Members
Points: 165 Visits: 88
Hi,

1.) Check the report to make sure it is with in the boundaries of the page size. (To get the Report properties click on the left corner at the top of the report designer, when you have done it correctly a black square appears - go to the other side of the screen and click the properties panel.) Page Size property should be 8.5in, 11in or 11in, 8.5in. Make sure also that the report will fit into either those two sizes. If the report is bigger then the page size you will get most of first page of your report on one page and the rest on the second.
2.) Make sure the margins are correct. If you report size is 8in across and your margins are set at 2 in left and right then it will print the first page an two different pages. (That will make your report actually 12 in across so, set you margins at .2in or something that is mathematically correct.)
3.) Also, if the left right margins are not helping with the issue, change the top and bottom margins to .5in or even less, which will sometimes help.
4.) CanGrow property for the textboxes is sometimes the culprit but I can not confirm or deny that.

I hope that helps. I had to write up something for work sor that problem.
Thanks, Kerrie
stevefromOZ
stevefromOZ
SSCrazy Eights
SSCrazy Eights (9.6K reputation)SSCrazy Eights (9.6K reputation)SSCrazy Eights (9.6K reputation)SSCrazy Eights (9.6K reputation)SSCrazy Eights (9.6K reputation)SSCrazy Eights (9.6K reputation)SSCrazy Eights (9.6K reputation)SSCrazy Eights (9.6K reputation)

Group: Moderators
Points: 9550 Visits: 3757

If you've got tables with hidden sections (visibility toggle?) You might want to ensure that you're running SP2 for Reporting Services, apparently it fixed a similar issue. Below is from the readme...

4.2.4 Tables with Details Sections

New in SP2. A table with a hidden or removed details section displays correct page breaks when rendered as an image or PDF file. Previously, a table with a hidden or removed details section would insert page breaks in unexpected locations.



Steve.
Syed Asim Rizvi
Syed Asim Rizvi
SSC Veteran
SSC Veteran (272 reputation)SSC Veteran (272 reputation)SSC Veteran (272 reputation)SSC Veteran (272 reputation)SSC Veteran (272 reputation)SSC Veteran (272 reputation)SSC Veteran (272 reputation)SSC Veteran (272 reputation)

Group: General Forum Members
Points: 272 Visits: 224

Check out this blog:

http://blogs.msdn.com/bwelcker/archive/2005/08/19/454043.aspx


ajashadi
ajashadi
SSC Veteran
SSC Veteran (237 reputation)SSC Veteran (237 reputation)SSC Veteran (237 reputation)SSC Veteran (237 reputation)SSC Veteran (237 reputation)SSC Veteran (237 reputation)SSC Veteran (237 reputation)SSC Veteran (237 reputation)

Group: General Forum Members
Points: 237 Visits: 40

Thank you everyone for the replies. I have set the margins as 0 and it worked for me. I tried by making margins very small 0.25 but still didnt work.

Thanks again.


Taco Man
Taco Man
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
Points: 11 Visits: 1

Here is another solution.

For example, if the size of your report in development layout is 13 inches wide including margins but you hide columns so that the run-time size of the report is under 11 inches with margins included, in the Report Properties you can set the PageSize width to 13 inches and the Interactive Size width property to 11 inches. With either property you need to make sure that the report width size plus your margins are less than or equal to the width value.


contactatif
contactatif
SSC Rookie
SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)

Group: General Forum Members
Points: 29 Visits: 93
Guys in SSRS 2008,

Very important property that can be easily ignored here is: ConsumeContainerWhitespace property of the Report. This is set to False by default, So the whitespace is not ignored by the renderer and is repeated on next page. Setting this to True solved all my Extra Blank Page problems in SSRS 2008.

Cheers.
latitiacasta
latitiacasta
SSC-Addicted
SSC-Addicted (468 reputation)SSC-Addicted (468 reputation)SSC-Addicted (468 reputation)SSC-Addicted (468 reputation)SSC-Addicted (468 reputation)SSC-Addicted (468 reputation)SSC-Addicted (468 reputation)SSC-Addicted (468 reputation)

Group: General Forum Members
Points: 468 Visits: 198
for me some report come with proper formate and some time its add blank pages
freezea
freezea
Grasshopper
Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)

Group: General Forum Members
Points: 21 Visits: 66
I'm using RAQ Report. It's a free excel-like java reporting tool. RAQ Report can export report to Word, Excel, Pdf easily. You can have a try. You can get free RAQ Report at http://www.raqsoft.com.

Welcome to my blog.Tongue
Kerrie Sorrell
Kerrie Sorrell
SSC-Enthusiastic
SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)

Group: General Forum Members
Points: 165 Visits: 88
What SSRS are you using, if there is any SP? Are you allowed to send me the rdl? There has to be something that is hidden, going beyond the margins, or the page property is not correct. I would need more information about what it is doing when you try to print.

Thanks,
Kerrie
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search