We have a sharepoint <\\ces\cesgypdav> that is a WebDAV connection, not an actual fileshare. A SSRS Subscription fails on file write ... "Failure writing file <name here > : The network path was not found" ... to this path.
Can SQL Reporting write to a WebDAV sharepoint?
WebDAV issue is known, need to 'work around'.This helps: http://sqljunkies.com/WebLog/tpagel/archive/2005/12/23/17682.aspx
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?
hello... have you solved it yet? I got the same issue too.|||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.
|||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?
|||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.|||
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
|||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.
|||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
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
|||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:
rint - Starting Function.
reportServerUrl = /ReportServer
reportPath = %2fAR%2fAR0006(b)+Statement+of+Accounts+-+Known+as+Name&rs
essionID=wkawsv3n2prf1gv2hnili455
reportName = AR0006(b) Statement of Accounts - Known as Name
CResourceManager:etLocaleInfo - 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:etLocaleInfo - Ending Function: 0x00000000.
CPrintDlg:rint - Starting Function.
CPrintDlg::InitializePrintDlg - Starting Function.
CPrintDlg::GetDefaultPrinterName - Starting Function.
CPrintDlg::GetDefaultPrinterName - Ending Function: 0x00000000.
CPrintDlg:etPrinterPaperSize - Starting Function.
CPrintDlg::GetDefaultPaperSetting - Starting Function.
CPrintDlg::GetDefaultPaperSetting - Ending Function: 0x00000000.
CPrintDlg:etPrinterPaperSize - Ending Function: 0x00000000.
CPrintDlg::InitializePrintDlg - Ending Function: 0x00000000.
CReport:etReportName - Starting Function.
CReport:etReportName - 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:tartFetchThread - Starting Function.
CReport::GetPageToFetch - Starting Function.
Page to fetch = 1
CReport::GetPageToFetch - Ending Function.
CReport:tartFetchThread - 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:erformFetch - Starting Function.
CReport::GetPaperSize - Starting Function.
Height = 11000, Width = 8500 IsMM = 0
CReport::GetPaperSize - Ending Function.
CResourceManager:etInvariantCulture - Starting Function.
CResourceManager:etInvariantCulture - 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&rsessionID=wkawsv3n2prf1gv2hnili455&rs:Command=Render&rs:format=IMAGE&rc
utputFormat=emfplus&rctartPage=1&rc:EndPage=65535&rcageWidth=8.5in&rcageHeight=11.0in&rc:MarginTop=3.048mm&rc:MarginBottom=3.048mm&rc:MarginLeft=3.048mm&rc:MarginRight=3.048mm&rsersistStreams=True
CPage::CreateEnhMetaFile - Starting Function.
CPage::CreateEnhMetaFile - Ending Function.
CReport:erformFetch - 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:erformFetch - Starting Function.
CReport::GetPaperSize - Starting Function.
Height = 11000, Width = 8500 IsMM = 0
CReport::GetPaperSize - Ending Function.
CResourceManager:etInvariantCulture - Starting Function.
CResourceManager:etInvariantCulture - 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&rsessionID=wkawsv3n2prf1gv2hnili455&rs:Command=Render&rs:format=IMAGE&rcutputFormat=emfplus&rctartPage=2&rc:EndPage=2&rcageWidth=8.5in&rcageHeight=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:
rawFile - Starting Function.
CPrintDlg:rawFile - 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:erformFetch - 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:rawFile - Starting Function.
CReport::FetchPage - Starting Function.
CReport:erformFetch - Starting Function.
CReport::GetPaperSize - Starting Function.
Height = 11000, Width = 8500 IsMM = 0
CReport::GetPaperSize - Ending Function.
CResourceManager:etInvariantCulture - Starting Function.
CResourceManager:etInvariantCulture - 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&rsessionID=wkawsv3n2prf1gv2hnili455&rs:Command=Render&rs:format=IMAGE&rcutputFormat=emfplus&rctartPage=3&rc:EndPage=3&rcageWidth=8.5in&rcageHeight=11.0in&rc:MarginTop=3.048mm&rc:MarginBottom=3.048mm&rc:MarginLeft=3.048mm&rc:MarginRight=3.048mm&rs:GetNextStream=True
CPrintDlg:rawFile - 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:erformFetch - 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:rawFile - Starting Function.
CReport::FetchPage - Starting Function.
CReport:erformFetch - Starting Function.
CReport::GetPaperSize - Starting Function.
Height = 11000, Width = 8500 IsMM = 0
CReport::GetPaperSize - Ending Function.
CResourceManager:etInvariantCulture - Starting Function.
CResourceManager:etInvariantCulture - 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&rsessionID=wkawsv3n2prf1gv2hnili455&rs:Command=Render&rs:format=IMAGE&rcutputFormat=emfplus&rctartPage=4&rc:EndPage=4&rcageWidth=8.5in&rcageHeight=11.0in&rc:MarginTop=3.048mm&rc:MarginBottom=3.048mm&rc:MarginLeft=3.048mm&rc:MarginRight=3.048mm&rs:GetNextStream=True
CPrintDlg:rawFile - 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.
