Printing Blank in Landscape

Hot Topic

Report Builder permissions
CreateProcessAsUser in SQLCLR
Using HTTP Post to secure parameter values?
Multi Column Report in SQLReporting Service 8.0
Connection Pooling
SQL Server "Recovery Scenarios" Document
~* Total Pages mismatch *~
How to install sql server 2005 developer edition over sql server express.
UDAs with .NET
Encryption in MDF file possible?

SQL Server

Stored Procedure being saved in System Stored Procedures
Pause between pages when printing RS report
URGENT: SQL 2005 : All schedulers appear deadlocked
Pixel to inch.
Uninstalling SQL Server 2005 Sept CTP
Concatenate field based on unique id. (Follow up)
get unspecified error when browsing data of CUBE
SQL Task with Variables
Replication with filter
Hierarchical Cascades

Printing Blank in Landscape

I've a report which is quite wide, and I'd like to print it in landscape.  In using the ActiveX control to change the print settings, the Preview looks great in Portrait, yet when I change it to landscape I get 8 pages of blank.

If I change it back to Portrait, I get an error saying there was an error rendering the report.

Has anyone had any luck with this

Thanks.


Answer this question

Printing Blank in Landscape

  • Frank Natoli

    I have set the page size correctly.  It's not that extra blank pages are printing, it's that all of the pages are blank.  Thanks for your help.

  • cnminor

    How can I get September build I did not find any hotfixes on September or later on MS download center.

  • under_way

    Please try this on the latest (September CTP) build. We fixed a bug in the June CTP that published the page settings backwards (width vs. height). Not sure if this was your problem.

  • sklett

    Actually, these appear to be 2 separate issues. 

    When directly printing in a landscaped format, even with a simple hello world report, all that prints are blank pages.  The latest attempt yielded more than 20 such before I cancelled the print job.

    I believe the error message came about as a compounded error, after switching to landscape, then previewing, then switching back.

    Have any of you been able to successfully print in landscape



  • Senthilvel

    specifically:

    "An error occured trying to render the report (0x80004005)"

  • Allan Stirrett

    I have now tried this with three vastly different printers on the corporate network, and all three have shown the same problem.  For now I am printing from the report designer, and the client will have to export to PDF or Excel and print from there.

    Thanks for your help, any other suggestions are very much appreciated.

  • Col in trouble

    I don't think the error has anything to do with the blank pages. Generally speaking, this will happen when the size of the report Body exceeds the size of the page. You should set the page size (not the body size) to landscape dimensions and maks sure that all of the contents fit on a single page, the body width plus margins should be less than the defined page width.

    A textbox or other report item can cause the width of the body to exceed the page width, even when the portion of the item that exceeds the width has no visible contents. In addition, horizontally growing report items (matrix data regions and images with set to automatically Autosize or Fit) can cause the body to grow as well.

  • american_werewolf

    Do you see the blank pages in preview as well Maybe you could try another printer driver. We have noticed that some drivers have strange behavior when trying to print in landscape.

  • Terence Lee

    I do see the blank pages in preview as well.  I'll give the printer driver a shot.  The odd thing is that it all prints fine from the report designer in landscape, it only seems to have trouble with the ActiveX control from the browser.


  • Printing Blank in Landscape
Answer this question