Client Printing Hangs

Hot Topic

Database Create error
async_network_io wait during replication
Log Shipping going out-of-sync
Using user variables in derived column transformation
MDX calculated member - showing null values
Interface not registered using Excel/mail?
Error on SQL cluster install
Copy Table from another table
How do I create a new db in sql 2005 express
SQL Performance Counters Missing

SQL Server

Report Designer for Reporting Services
Howto suppress FETCH output
Error importing excel file
error in transfer sql task
hi experts, can anyone have a look my simple questions, thxxx a lot!
SQL Express 2005 RTM?
How can SQL Server 2005 Reporting help me ?
Bug: "ALTER TABLE *** WITH NOCHECK" does not work for SQL Server 2005
Problem while deploying Report on server
Give permissions programatically with c#

Client Printing Hangs

We are accessing SSRS reports using web service. We call the Render the reports using http://<server>/ReportServer/Pages/ReportViewer.aspx reportName&rs:Command=Render

All reports render fine. However for one particular report when we click the print button on the report viewer in IE, Active-x pops up a message "Printing Now" and hangs eternally.

The error occurs even when I am logged in with Admin privileges to the machine and Active-X client works fine for other reports except this one.

Work-around tried: If I call the same report from Report Manager it works fine. Even on the server I have been able to print the report fine.

The report is just 1 page and the data loaded is also not very heavy. Any idea why client side report printing hangs



Answer this question

Client Printing Hangs

  • XIII

    We have the same problem. Except that the problem occurs on a report containing a matrix control and no subreports. It started happening with a new version of a report. When I deployed an old version of the same report (that printed nicely earlier), it also hangs during printing.

    We have RS 2000 with SP2.

  • novice of the novices

    I also have started having the pop up message "Printing Now" and the report hangs eternally. it also hangs with
    Print Preview... Report Services/Report Viewer has been working fine( and being in Production) for about a year now...

    I gotta get this fixed!!!

    Surely some MS Grues are gonna lead us to a solution soon!!! Thank In Advance...



  • jdang

    Folks, we've seen a similar issue in our testing but were not able to reproduce the scenario for it. Without a stable repro, it makes it close to impossible to identify and fix the issue.

    Would it be possible for one/some of you to follow the instructions that Brad provided earlier in this thread and then post a bug with that information, the RDL you're using, and (if possible) a sample dataset that causes the issue on our product feedback site:

    http://lab.msdn.microsoft.com/productfeedback/

    Thanks for your help on this,

    -Lukasz



  • Bill

    Hi quantum,

    Have you tried unstinstalling and reinstalling the Print Control

    You can set a registry key to on the client machine that will start client print logging. It creates a log file in your temp folder. Here is the key.

    Windows Registry Editor Version 5.00

    [HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Reporting Services]
    "LogRSClientPrintInfo"=dword:00000001

    You can send me the log file and I can take a look to see if I know what the issue is. Remove the online in my email address.



  • Clemens Reijnen

    Hi as i writen i was able to solve it if i have the same problem

    on my machnes it was the IE. what wersion are u using


  • Saskia1

    I had similar problem with printing report and was able to solve the problem

    it was IE, i had 2 machines one working one not so i compared dhe IE dll and

    found that the version of the dll was the same but not the file_version

    after i replaced the DLL from working machine iwas functioning again

    the DLL where : browseui.dll, shdocvw.dll, urlmon.dll ,mshtml.dll, wininet.dll

  • salvodif

    Hi,

    I have installed SQL 2000 reporting services 2000 SP2.

    When i try to print report by clicking print button in HTML tool bar i get error as "Error occured while printing 0x80040005"

    I have turned on client print log, but there in no useful information

    Regards

    Shakeela



  • Igor24

    the issue seems to a problem the local machine and the rights it has to install exes. My machine our organization stop us from installing any exes from the web etc. I have the same printing issue and the browser hangs.

    But when I tried the same page from a machine in the DMZ zone which does not have restrictions, the priting is working fine.

  • Cyberflight

    I am having the same issue, started yesterday. All of a sudden, the report wouldn't print.

    here is the data from the printlog

    CRSClientPrint:Stick out tonguerint - Starting Function.
    reportServerUrl = /ReportServer
    reportPath = %2fAR%2fAR0006(b)+Statement+of+Accounts+-+Known+as+Name&rsTongue TiedessionID=wkawsv3n2prf1gv2hnili455
    reportName = AR0006(b) Statement of Accounts - Known as Name
    CResourceManager:Tongue TiedetLocaleInfo - Starting Function.
    SetUICulture - Starting Function.
    Attempted UI LCID = 9
    Using UI LCID = 1033
    SetUICulture - Ending Function.
    CResourceManager::LoadResourceDLL - Starting Function.
    CResourceManager::LoadResourceDLL - Ending Function: 0x00000000.
    CResourceManager::CanUseCurrentLocale - Starting Function.
    CResourceManager::CanUseCurrentLocale - Ending Function.
    CResourceManager::LoadGDIPlus - Starting Function.
    CResourceManager::LoadGDIPlus - Ending Function: 0x00000000.
    Attempted culture = 1033
    Using culture = 1033
    Culture name = English_United States.1252
    CResourceManager:Tongue TiedetLocaleInfo - Ending Function: 0x00000000.
    CPrintDlg:Stick out tonguerint - Starting Function.
    CPrintDlg::InitializePrintDlg - Starting Function.
    CPrintDlg::GetDefaultPrinterName - Starting Function.
    CPrintDlg::GetDefaultPrinterName - Ending Function: 0x00000000.
    CPrintDlg:Tongue TiedetPrinterPaperSize - Starting Function.
    CPrintDlg::GetDefaultPaperSetting - Starting Function.
    CPrintDlg::GetDefaultPaperSetting - Ending Function: 0x00000000.
    CPrintDlg:Tongue TiedetPrinterPaperSize - Ending Function: 0x00000000.
    CPrintDlg::InitializePrintDlg - Ending Function: 0x00000000.
    CReport:Tongue TiedetReportName - Starting Function.
    CReport:Tongue TiedetReportName - Ending Function: 0x00000000.
    CReport::Fetch - Starting Function.
    CReport::ComparePrintInfo - Starting Function.
    Value of diff = 2
    CReport::ComparePrintInfo - Ending Function.
    CReport::ClearPages - Starting Function.
    CReport::ClearFetchedPages - Starting Function.
    CReport::ClearFetchedPages - Ending Function.
    CReport::ClearPages - Ending Function.
    CReport::ResetNextFetch - Starting Function.
    Next Fetch set to 1
    CReport::ResetNextFetch - Ending Function.
    CReport:Tongue TiedtartFetchThread - Starting Function.
    CReport::GetPageToFetch - Starting Function.
    Page to fetch = 1
    CReport::GetPageToFetch - Ending Function.
    CReport:Tongue TiedtartFetchThread - Ending Function: 0x00000000.
    CReport::Fetch - Ending Function: 0x00000000.
    CPrintPreviewDlg::CreatePreviewDialog - Starting Function.
    CReport::GetPage - Starting Function.
    Page = 1
    CReport::FetchThreadMain - Starting Function.
    CReport::GetPageWrapper - Starting Function.
    Page wrapper = 0x00000000
    CReport::GetPageWrapper - Ending Function.
    CReport::GetPageToFetch - Starting Function.
    Page to fetch = 1
    CReport::GetPageToFetch - Ending Function.
    CReport::FetchAllPages - Starting Function.
    CReport:Stick out tongueerformFetch - Starting Function.
    CReport::GetPaperSize - Starting Function.
    Height = 11000, Width = 8500 IsMM = 0
    CReport::GetPaperSize - Ending Function.
    CResourceManager:Tongue TiedetInvariantCulture - Starting Function.
    CResourceManager:Tongue TiedetInvariantCulture - Ending Function: 0x00000000.
    CResourceManager::ResetCulture - Starting Function.
    CResourceManager::ResetCulture - Ending Function: 0x00000000.
    Url = http://10.1.1.130/ReportServer %2fAR%2fAR0006(b)+Statement+of+Accounts+-+Known+as+Name&rsTongue TiedessionID=wkawsv3n2prf1gv2hnili455&rs:Command=Render&rs:format=IMAGE&rcSurpriseutputFormat=emfplus&rcTongue TiedtartPage=1&rc:EndPage=65535&rcStick out tongueageWidth=8.5in&rcStick out tongueageHeight=11.0in&rc:MarginTop=3.048mm&rc:MarginBottom=3.048mm&rc:MarginLeft=3.048mm&rc:MarginRight=3.048mm&rsStick out tongueersistStreams=True
    CPage::CreateEnhMetaFile - Starting Function.
    CPage::CreateEnhMetaFile - Ending Function.
    CReport:Stick out tongueerformFetch - Ending Function.
    CReport::FetchAllPages - Ending Function.
    CReport::GetPageWrapper - Starting Function.
    Page wrapper = 0x05E76D00
    CReport::GetPageWrapper - Ending Function.
    CReport::GetPageToFetch - Starting Function.
    Page to fetch = 2
    CReport::GetPageToFetch - Ending Function.
    CReport::GetPage - Ending Function: 0x00000000.
    CReport::FetchPage - Starting Function.
    CReport:Stick out tongueerformFetch - Starting Function.
    CReport::GetPaperSize - Starting Function.
    Height = 11000, Width = 8500 IsMM = 0
    CReport::GetPaperSize - Ending Function.
    CResourceManager:Tongue TiedetInvariantCulture - Starting Function.
    CResourceManager:Tongue TiedetInvariantCulture - Ending Function: 0x00000000.
    CResourceManager::ResetCulture - Starting Function.
    CResourceManager::ResetCulture - Ending Function: 0x00000000.
    Url = http://10.1.1.130/ReportServer %2fAR%2fAR0006(b)+Statement+of+Accounts+-+Known+as+Name&rsTongue TiedessionID=wkawsv3n2prf1gv2hnili455&rs:Command=Render&rs:format=IMAGE&rcSurpriseutputFormat=emfplus&rcTongue TiedtartPage=2&rc:EndPage=2&rcStick out tongueageWidth=8.5in&rcStick out tongueageHeight=11.0in&rc:MarginTop=3.048mm&rc:MarginBottom=3.048mm&rc:MarginLeft=3.048mm&rc:MarginRight=3.048mm&rs:GetNextStream=True
    CReport::GetPaperSize - Starting Function.
    Height = 11000, Width = 8500 IsMM = 0
    CReport::GetPaperSize - Ending Function.
    CReport::GetPage - Starting Function.
    Page = 1
    CReport::GetPageWrapper - Starting Function.
    Page wrapper = 0x05E76D00
    CReport::GetPageWrapper - Ending Function.
    CReport::GetPage - Ending Function: 0x00000000.
    CPrintDlg:Big SmilerawFile - Starting Function.
    CPrintDlg:Big SmilerawFile - Ending Function: 0x00000000.
    CReport::GetPaperSize - Starting Function.
    Height = 11000, Width = 8500 IsMM = 0
    CReport::GetPaperSize - Ending Function.
    CReport::GetPage - Starting Function.
    Page = 2
    CReport::GetPageWrapper - Starting Function.
    Page wrapper = 0x00000000
    CReport::GetPageWrapper - Ending Function.
    CPage::CreateEnhMetaFile - Starting Function.
    CPage::CreateEnhMetaFile - Ending Function.
    CReport:Stick out tongueerformFetch - Ending Function.
    CReport::FetchPage - Ending Function.
    CReport::GetPageWrapper - Starting Function.
    Page wrapper = 0x05EA5908
    CReport::GetPageWrapper - Ending Function.
    CReport::GetPageToFetch - Starting Function.
    Page to fetch = 3
    CReport::GetPageToFetch - Ending Function.
    CReport::GetPage - Ending Function: 0x00000000.
    CPrintDlg:Big SmilerawFile - Starting Function.
    CReport::FetchPage - Starting Function.
    CReport:Stick out tongueerformFetch - Starting Function.
    CReport::GetPaperSize - Starting Function.
    Height = 11000, Width = 8500 IsMM = 0
    CReport::GetPaperSize - Ending Function.
    CResourceManager:Tongue TiedetInvariantCulture - Starting Function.
    CResourceManager:Tongue TiedetInvariantCulture - Ending Function: 0x00000000.
    CResourceManager::ResetCulture - Starting Function.
    CResourceManager::ResetCulture - Ending Function: 0x00000000.
    Url = http://10.1.1.130/ReportServer %2fAR%2fAR0006(b)+Statement+of+Accounts+-+Known+as+Name&rsTongue TiedessionID=wkawsv3n2prf1gv2hnili455&rs:Command=Render&rs:format=IMAGE&rcSurpriseutputFormat=emfplus&rcTongue TiedtartPage=3&rc:EndPage=3&rcStick out tongueageWidth=8.5in&rcStick out tongueageHeight=11.0in&rc:MarginTop=3.048mm&rc:MarginBottom=3.048mm&rc:MarginLeft=3.048mm&rc:MarginRight=3.048mm&rs:GetNextStream=True
    CPrintDlg:Big SmilerawFile - Ending Function: 0x00000000.
    CReport::GetPaperSize - Starting Function.
    Height = 11000, Width = 8500 IsMM = 0
    CReport::GetPaperSize - Ending Function.
    CReport::GetPage - Starting Function.
    Page = 3
    CReport::GetPageWrapper - Starting Function.
    Page wrapper = 0x00000000
    CReport::GetPageWrapper - Ending Function.
    CPage::CreateEnhMetaFile - Starting Function.
    CPage::CreateEnhMetaFile - Ending Function.
    CReport:Stick out tongueerformFetch - Ending Function.
    CReport::FetchPage - Ending Function.
    CReport::GetPageWrapper - Starting Function.
    Page wrapper = 0x05ED4798
    CReport::GetPageWrapper - Ending Function.
    CReport::GetPage - Ending Function: 0x00000000.
    CReport::GetPageToFetch - Starting Function.
    Page to fetch = 4
    CReport::GetPageToFetch - Ending Function.
    CPrintDlg:Big SmilerawFile - Starting Function.
    CReport::FetchPage - Starting Function.
    CReport:Stick out tongueerformFetch - Starting Function.
    CReport::GetPaperSize - Starting Function.
    Height = 11000, Width = 8500 IsMM = 0
    CReport::GetPaperSize - Ending Function.
    CResourceManager:Tongue TiedetInvariantCulture - Starting Function.
    CResourceManager:Tongue TiedetInvariantCulture - Ending Function: 0x00000000.
    CResourceManager::ResetCulture - Starting Function.
    CResourceManager::ResetCulture - Ending Function: 0x00000000.
    Url = http://10.1.1.130/ReportServer %2fAR%2fAR0006(b)+Statement+of+Accounts+-+Known+as+Name&rsTongue TiedessionID=wkawsv3n2prf1gv2hnili455&rs:Command=Render&rs:format=IMAGE&rcSurpriseutputFormat=emfplus&rcTongue TiedtartPage=4&rc:EndPage=4&rcStick out tongueageWidth=8.5in&rcStick out tongueageHeight=11.0in&rc:MarginTop=3.048mm&rc:MarginBottom=3.048mm&rc:MarginLeft=3.048mm&rc:MarginRight=3.048mm&rs:GetNextStream=True
    CPrintDlg:Big SmilerawFile - Ending Function: 0x00000000.
    CReport::GetPaperSize - Starting Function.
    Height = 11000, Width = 8500 IsMM = 0
    CReport::GetPaperSize - Ending Function.
    CReport::GetPage - Starting Function.
    Page = 4
    CReport::GetPageWrapper - Starting Function.
    Page wrapper = 0x00000000
    CReport::GetPageWrapper - Ending Function.

  • pistolpig

    I'm having a very similar issue (SQL 2005 here). However instead of hanging at the "Printing now..." part it reboots the client.

    I don't have much to add log-wise but this issue seems to have started after we moved to sp1.

    It doesn't happen on all machines. I cannot see any pattern for the crashing machines.


  • Jens K&amp;#246;hler

    Hi Brad,

    I couldn't find the registry keys on my machine. We are using SQL Server 2005 and Reporting Services 2005. Reports are being rendered via browser using ReportViewer.aspx with various query string parameters.

    I am thinking that this is not a stable approach to render reports from Report Server. Do you know if directly accessing reports from client browser using ReportViewer.aspx is not a recommended approach

    Thanks

    Uday Hegde

  • Jellcat

    We are also experiencing the problem from all client PCs. The problem only occurs on one report that contains a subreport. Besides the IE browser, it also hangs when trying to print from Studio 2005.

    Has anyone solved this problem yet


  • Carlik

    hello... have you solved it yet I got the same issue too.

  • Steve Cowell

    We are having the same issue described above, however it only appears to effect the larger reports. The other interesting thing is that we get this error, if the client waits long enough - about 10 min.

    INVALID PAGE NUMBER
    The requested page does not exist.

    Can someone give me some more specifics as to how to run the client logging utiltity mentioned above. I am assuming that the registry edit should be made on the server - not the client Also, where does the log file go - exactly. If it is in a %temp% directory, is this is the directory for the user under which reporting services runs, or the IIS user, or the local user or what

    We are running:
    Windows Server 2003, SP2, 64bit
    SQL Server 2000, SP4, clustered, 64bit
    IIS 6.0 on Windows Server 2003
  • Client Printing Hangs
Answer this question