Reporting Services 2005 & IE7 Beta

When trying to print an RS2005 report, I keep getting the error "Unable to
load client print control". This is because the RSClientPrint ActiveX
control is not loaded. I have noticed that in IE7 Beta is not automatically
prompting to download the control. Has anyone been successful in running
this under IE7? I am using 7.0.5112.0, Beta 1.
* "Enable download for the ActiveX client print control" is enabled on the
server.
* Report Server added to the Trusted Sites list
* Download Signed ActiveX Controls = Enable
* Script ActiveX Controls Marked Safe for Scripting = Enable
* Automatic Prompting for ActiveX Controls = Enable
Works fine under IE6.
Thanks,
-sYou may want to insure that it is enabled.
Tools->Internet Options->Programs->Manage Add-ons
If RSCleintPrint Class is enabled, you may want to delete it and allow
it to be reinstalled.
Hope you get it to working,
Lonsql

Reporting services 2000 / 2005 parameters

Hi all,

Is there any way to pass a dataset parameter in RS 2000? Basicly, I have some data in my web page and want to print it. But I don't want to create another page to pass parameters to RS. I want to print the page as it is with the data already in the page, so if there is a way I can send the data through a dataset to the report directly, would be great. Is there?

Thank you very much,

Marco

You can give this a try.

http://blogs.msdn.com/bryanke/archive/2004/09/13/229129.aspx

cheers,

Andrew

|||The link from the blog is not valid.|||

More ideas, please

Thanks,

Marco

|||

I found it after googling custom dataset reporting services.

http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=b8468707-56ef-4864-ac51-d83fc3273fe5

cheers,

Andrew

|||

Good article, Andrew.

Thank you very much

Regards,

Marco

Reporting Services 2000 - Printing Hangs

I am running SQL 2000 SP4 with Reporting Services 2000 SP2. Reporting services hangs when I try to print reports. The reports render okay, and when I click on the print icon, I get the appropriate dialog box. Once I click "OK", I get the "Printing..." dialog that says "Printing Now...", but it never prints, and the window eventually stops responding. As far as I am aware, no changes have been made to the server, and it was working fine approximately 10 days ago. Below is the contents of my RS Client Print Log (%Temp%\LOG56.tmp):

CRSClientPrint::Print - Starting Function.
reportServerUrl = http://reportsrv/ReportServer
reportPath = %2fEngineering%2fRamz+-+Development%2fDEV_Reports%2fContract_Project_By_State&ContractStateDesc=Active
reportName = Contract_Project_By_State
CResourceManager::SetLocaleInfo - 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::SetLocaleInfo - Ending Function: 0x00000000.
CPrintDlg::Print - Starting Function.
CPrintDlg::InitializePrintDlg - Starting Function.
CPrintDlg::GetDefaultPrinterName - Starting Function.
CPrintDlg::GetDefaultPrinterName - Ending Function: 0x00000000.
CPrintDlg::SetPrinterPaperSize - Starting Function.
CPrintDlg::SetPrinterPaperSize - Ending Function: 0x00000000.
CPrintDlg::InitializePrintDlg - Ending Function: 0x00000000.
CReport::SetReportName - Starting Function.
CReport::SetReportName - Ending Function: 0x00000000.
CPrintDlg::PrintReportPages - Starting Function.
CCancelDlg::StartDialog - Starting Function.
CCancelDlg::StartDialog - 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::StartFetchThread - Starting Function.
CReport::GetPageToFetch - Starting Function.
Page to fetch = 1
CReport::GetPageToFetch - Ending Function.
CReport::StartFetchThread - Ending Function: 0x00000000.
CReport::Fetch - Ending Function: 0x00000000.
CReport::GetPage - Starting Function.
Page = 1
CReport::GetPageWrapper - Starting Function.
Page wrapper = 0x00000000
CReport::GetPageWrapper - Ending Function.
CReport::FetchThreadMain - Starting Function.
CReport::GetPageToFetch - Starting Function.
Page to fetch = 1
CReport::GetPageToFetch - Ending Function.
CReport::FetchAllPages - Starting Function.
CReport::PerformFetch - Starting Function.
CReport::GetPaperSize - Starting Function.
Height = 8500, Width = 11000 IsMM = 0
CReport::GetPaperSize - Ending Function.
CResourceManager::SetInvariantCulture - Starting Function.
CResourceManager::SetInvariantCulture - Ending Function: 0x00000000.
CResourceManager::ResetCulture - Starting Function.
CResourceManager::ResetCulture - Ending Function: 0x00000000.
Url = http://reportsrv/ReportServer?%2fEngineering%2fRamz+-+Development%2fDEV_Reports%2fContract_Project_By_State&ContractStateDesc=Active&rs:Command=Render&rs:format=IMAGE&rc:OutputFormat=emf&rc:StartPage=1&rc:EndPage=65535&rc:PageWidth=11.0in&rc:PageHeight=8.500in&rc:MarginTop=6.350mm&rc:MarginBottom=6.350mm&rc:MarginLeft=6.350mm&rc:MarginRight=6.350mm&rs:PersistStreams=True

Can anyone give me any ideas as to how to troubleshoot this issue?

Hi Patrick,

If that is all that is in the log, it looks like the service might be having an issue with rendering the Url. Paste the Url from the print log file into Internet Explorer and see if it renderers an emf image.

Also, you can check the Report Server log files for any exceptions from the rendering. You can find the log directory, Logfiles next to the Report Server installation binaries directory.

Did you change any settings on your server to use Cookieless Sessions? I notice that the SessionID is not stored in the URL.

|||

I have not changed any cookie settings. When I paste the URL into the browser, I get a prompt for credentials, and then an HTTP 401 (Unauthorized) error. I am an Administrator, so my credentials should be valid. The ReportServer log showed the following:

w3wp!webserver!1df0!01/08/2007-12:34:55:: i INFO: Processed folder '/'
w3wp!webserver!1df0!01/08/2007-12:34:56:: i INFO: Processed folder '/Engineering'
w3wp!webserver!1df0!01/08/2007-12:34:58:: i INFO: Processed folder '/Engineering/Ramz - Development'
w3wp!webserver!1df0!01/08/2007-12:34:59:: i INFO: Processed folder '/Engineering/Ramz - Development/DEV_Reports'
w3wp!library!83c!01/08/2007-12:35:01:: i INFO: Initializing ResponseBufferSizeKb to default value of '64' KB because it was not specified in Server system properties.
w3wp!library!83c!01/08/2007-12:35:01:: i INFO: Initializing UseSessionCookies to 'True' as specified in Server system properties.
w3wp!library!83c!01/08/2007-12:35:01:: i INFO: Initializing EnableIntegratedSecurity to 'True' as specified in Server system properties.
w3wp!library!1e4c!01/08/2007-12:35:06:: i INFO: Initializing SessionTimeout to '600' second(s) as specified in Server system properties.
w3wp!library!1e4c!01/08/2007-12:35:06:: i INFO: Initializing EnableClientPrinting to default value of 'True' because it was not specified in Server system properties.
w3wp!library!1e4c!01/08/2007-12:35:06:: i INFO: Call to RenderFirst( '/Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State' )
w3wp!library!1e4c!01/08/2007-12:35:07:: Using folder C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\RSTempFiles for temporary files.
w3wp!library!1e4c!01/08/2007-12:35:08:: i INFO: Initializing EnableExecutionLogging to 'False' as specified in Server system properties.
w3wp!library!1e2c!1/8/2007-12:35:08:: i INFO: Initializing SqlStreamingBufferSize to default value of '64640' Bytes because it was not specified in Server system properties.
w3wp!webserver!1e4c!01/08/2007-12:35:08:: i INFO: Processed report. Report='/Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State', Stream=''
w3wp!library!1e2c!1/8/2007-12:35:08:: i INFO: Initializing SnapshotCompression to 'SQL' as specified in Server system properties.
w3wp!library!1e4c!01/08/2007-12:35:08:: i INFO: Initializing SessionAccessTimeout to default value of '600' seconds because it was not specified in Server system properties.
w3wp!webserver!1e4c!01/08/2007-12:35:08:: i INFO: Processed report. Report='/Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State', Stream='d60bcf42-3d04-4642-8772-8296be509a7b'
w3wp!library!1e2c!01/08/2007-12:35:39:: i INFO: Call to RenderNext( '/Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State' )
w3wp!cache!1e2c!01/08/2007-12:35:39:: i INFO: Item not cacheable: - PersistStreams /Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State
w3wp!chunks!1e2c!01/08/2007-12:35:39:: i INFO: ### GetReportChunk('RenderingInfo_IMAGE', 2), chunk was not found! this=25ac3238-2ba1-4406-befb-f46907e5d068
w3wp!webserver!1df0!01/08/2007-12:35:41:: i INFO: Processed report. Report='/Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State', Stream=''
w3wp!cache!1e2c!01/08/2007-12:36:17:: i INFO: Session live: /Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State
w3wp!library!83c!01/08/2007-12:36:17:: i INFO: Call to RenderNext( '/Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State' )
w3wp!cache!83c!01/08/2007-12:36:17:: i INFO: Item not cacheable: - PersistStreams /Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State
w3wp!chunks!83c!01/08/2007-12:36:17:: i INFO: ### GetReportChunk('RenderingInfo_IMAGE', 2), chunk was not found! this=25ac3238-2ba1-4406-befb-f46907e5d068
w3wp!webserver!1df0!01/08/2007-12:36:18:: i INFO: Processed report. Report='/Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State', Stream=''
w3wp!cache!83c!01/08/2007-12:36:55:: i INFO: Session live: /Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State
w3wp!library!1e4c!01/08/2007-12:37:57:: i INFO: Call to RenderFirst( '/Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State' )
w3wp!webserver!1df0!01/08/2007-12:37:58:: i INFO: Processed report. Report='/Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State', Stream=''
w3wp!cache!1e4c!01/08/2007-12:38:33:: i INFO: Item not cacheable: - PersistStreams /Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State
w3wp!cache!1e4c!01/08/2007-12:38:33:: i INFO: Item not cacheable: - PersistStreams /Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State
w3wp!cache!1e4c!01/08/2007-12:38:33:: i INFO: Item not cacheable: - PersistStreams /Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State
w3wp!cache!1e4c!01/08/2007-12:38:33:: i INFO: Item not cacheable: - PersistStreams /Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State
w3wp!cache!1e4c!01/08/2007-12:38:33:: i INFO: Item not cacheable: - PersistStreams /Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State

|||

I get the following in the IIS log when I try to render the report:

2007-01-09 15:42:12 XXX.XXX.XXX.XXX GET /ReportServer %2fEngineering%2fRamz+-+Development%2fDEV_Reports%2fContract_Project_By_State&ContractStateDesc=Active&rs:Command=Render&rs:format=IMAGE&rc:OutputFormat=emf&rc:StartPage=1&rc:EndPage=65535&rc:PageWidth=11.0in&rc:PageHeight=8.500in&rc:MarginTop=6.350mm&rc:MarginBottom=6.350mm&rc:MarginLeft=6.350mm&rc:MarginRight=6.350mm&rs:PersistStreams=True 80 DOMAIN\pburcham XXX.XXX.XXX.XXX Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 200
2007-01-09 15:42:49 XXX.XXX.XXX.XXX GET /ReportServer %2fEngineering%2fRamz+-+Development%2fDEV_Reports%2fContract_Project_By_State&ContractStateDesc=Active&rs:Command=Render&rs:format=IMAGE&rc:OutputFormat=emf&rc:StartPage=1&rc:EndPage=65535&rc:PageWidth=11.0in&rc:PageHeight=8.500in&rc:MarginTop=6.350mm&rc:MarginBottom=6.350mm&rc:MarginLeft=6.350mm&rc:MarginRight=6.350mm&rs:PersistStreams=True 80 - XXX.XXX.XXX.XXX Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 401
2007-01-09 15:42:49 XXX.XXX.XXX.XXX GET /ReportServer %2fEngineering%2fRamz+-+Development%2fDEV_Reports%2fContract_Project_By_State&ContractStateDesc=Active&rs:Command=Render&rs:format=IMAGE&rc:OutputFormat=emf&rc:StartPage=1&rc:EndPage=65535&rc:PageWidth=11.0in&rc:PageHeight=8.500in&rc:MarginTop=6.350mm&rc:MarginBottom=6.350mm&rc:MarginLeft=6.350mm&rc:MarginRight=6.350mm&rs:PersistStreams=True 80 DOMAIN\pburcham XXX.XXX.XXX.XXX Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 200
2007-01-09 15:42:49 XXX.XXX.XXX.XXX GET /ReportServer %2fEngineering%2fRamz+-+Development%2fDEV_Reports%2fContract_Project_By_State&ContractStateDesc=Active&rs:Command=Render&rs:format=IMAGE&rc:OutputFormat=emf&rc:StartPage=1&rc:EndPage=65535&rc:PageWidth=11.0in&rc:PageHeight=8.500in&rc:MarginTop=6.350mm&rc:MarginBottom=6.350mm&rc:MarginLeft=6.350mm&rc:MarginRight=6.350mm&rs:PersistStreams=True 80 - XXX.XXX.XXX.XXX Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 401
2007-01-09 15:43:25 XXX.XXX.XXX.XXX GET /ReportServer %2fEngineering%2fRamz+-+Development%2fDEV_Reports%2fContract_Project_By_State&ContractStateDesc=Active&rs:Command=Render&rs:format=IMAGE&rc:OutputFormat=emf&rc:StartPage=1&rc:EndPage=65535&rc:PageWidth=11.0in&rc:PageHeight=8.500in&rc:MarginTop=6.350mm&rc:MarginBottom=6.350mm&rc:MarginLeft=6.350mm&rc:MarginRight=6.350mm&rs:PersistStreams=True 80 DOMAIN\pburcham XXX.XXX.XXX.XXX Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 200
2007-01-09 15:43:25 XXX.XXX.XXX.XXX GET /ReportServer %2fEngineering%2fRamz+-+Development%2fDEV_Reports%2fContract_Project_By_State&ContractStateDesc=Active&rs:Command=Render&rs:format=IMAGE&rc:OutputFormat=emf&rc:StartPage=1&rc:EndPage=65535&rc:PageWidth=11.0in&rc:PageHeight=8.500in&rc:MarginTop=6.350mm&rc:MarginBottom=6.350mm&rc:MarginLeft=6.350mm&rc:MarginRight=6.350mm&rs:PersistStreams=True 80 - XXX.XXX.XXX.XXX Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 401
2007-01-09 15:44:00 XXX.XXX.XXX.XXX GET /ReportServer %2fEngineering%2fRamz+-+Development%2fDEV_Reports%2fContract_Project_By_State&ContractStateDesc=Active&rs:Command=Render&rs:format=IMAGE&rc:OutputFormat=emf&rc:StartPage=1&rc:EndPage=65535&rc:PageWidth=11.0in&rc:PageHeight=8.500in&rc:MarginTop=6.350mm&rc:MarginBottom=6.350mm&rc:MarginLeft=6.350mm&rc:MarginRight=6.350mm&rs:PersistStreams=True 80 DOMAIN\pburcham XXX.XXX.XXX.XXX Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 200
2007-01-09 15:44:00 XXX.XXX.XXX.XXX GET /ReportServer %2fEngineering%2fRamz+-+Development%2fDEV_Reports%2fContract_Project_By_State&ContractStateDesc=Active&rs:Command=Render&rs:format=IMAGE&rc:OutputFormat=emf&rc:StartPage=1&rc:EndPage=65535&rc:PageWidth=11.0in&rc:PageHeight=8.500in&rc:MarginTop=6.350mm&rc:MarginBottom=6.350mm&rc:MarginLeft=6.350mm&rc:MarginRight=6.350mm&rs:PersistStreams=True 80 - XXX.XXX.XXX.XXX Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 401
2007-01-09 15:47:09 XXX.XXX.XXX.XXX GET /ReportServer %2fEngineering%2fRamz+-+Development%2fDEV_Reports%2fContract_Project_By_State&ContractStateDesc=Active&rs:Command=Render&rs:format=IMAGE&rc:OutputFormat=emf&rc:StartPage=1&rc:EndPage=65535&rc:PageWidth=11.0in&rc:PageHeight=8.500in&rc:MarginTop=6.350mm&rc:MarginBottom=6.350mm&rc:MarginLeft=6.350mm&rc:MarginRight=6.350mm&rs:PersistStreams=True 80 - XXX.XXX.XXX.XXX Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 401
2007-01-09 15:47:14 XXX.XXX.XXX.XXX GET /ReportServer %2fEngineering%2fRamz+-+Development%2fDEV_Reports%2fContract_Project_By_State&ContractStateDesc=Active&rs:Command=Render&rs:format=IMAGE&rc:OutputFormat=emf&rc:StartPage=1&rc:EndPage=65535&rc:PageWidth=11.0in&rc:PageHeight=8.500in&rc:MarginTop=6.350mm&rc:MarginBottom=6.350mm&rc:MarginLeft=6.350mm&rc:MarginRight=6.350mm&rs:PersistStreams=True 80 DOMAIN\pburcham XXX.XXX.XXX.XXX Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 200
2007-01-09 15:47:14 XXX.XXX.XXX.XXX GET /ReportServer %2fEngineering%2fRamz+-+Development%2fDEV_Reports%2fContract_Project_By_State&ContractStateDesc=Active&rs:Command=Render&rs:format=IMAGE&rc:OutputFormat=emf&rc:StartPage=1&rc:EndPage=65535&rc:PageWidth=11.0in&rc:PageHeight=8.500in&rc:MarginTop=6.350mm&rc:MarginBottom=6.350mm&rc:MarginLeft=6.350mm&rc:MarginRight=6.350mm&rs:PersistStreams=True 80 - XXX.XXX.XXX.XXX Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 401

It appears that SSRS is not passing my credentials all of the time, only sometimes. It also appears that multiple requests are made for the same report. Any ideas as to why this might be?

Reporting Services - Rendering

I have created reports using Reporting Services and the problem I am having is with the Print Layout. I view a report with parameters and print. I then change the parameters and click 'View Report' again and the new report is displayed. However, the report does not refresh in the Print Layout, so if I try to print the 2nd report, the first report is the one that is printed. Any ideas how to solve this?

Thanks

Quite simple.

Close Print Layout when you change the parameters and open it after the new report is displayed. Print Layout is rendered upon demand, and just changing the parameters is not refreshing the Print Layout screen.

|||Bdot - aparerntly this is a confirmed bug but you can work around it in code by hooking up to the ViewButtonClick event and calling RefreshReport.

c/o http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=267834&SiteID=1

Reporting Services - Rendering

I have created reports using Reporting Services and the problem I am having is with the Print Layout. I view a report with parameters and print. I then change the parameters and click 'View Report' again and the new report is displayed. However, the report does not refresh in the Print Layout, so if I try to print the 2nd report, the first report is the one that is printed. Any ideas how to solve this?

Thanks

Quite simple.

Close Print Layout when you change the parameters and open it after the new report is displayed. Print Layout is rendered upon demand, and just changing the parameters is not refreshing the Print Layout screen.

|||Bdot - aparerntly this is a confirmed bug but you can work around it in code by hooking up to the ViewButtonClick event and calling RefreshReport.

c/o http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=267834&SiteID=1

Reporting Services

I need to make a report that print out a list of reports that is currently in
the Reporting Services Server.
Is there a way to do that?
Scott BurkeIn the Report Server Metadata Database
Select * from dbo.Catalog where type = 2
There are also some sample reports which come with SQL Server that might be
helpful to you..
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it'''s
community of SQL Professionals.
See you at the PASS Conference
"Scott Burke" wrote:
> I need to make a report that print out a list of reports that is currently in
> the Reporting Services Server.
> Is there a way to do that?
> Scott Burke

Reporting Service - print button shown on IE not shown on Firefox

Hi, I have my web application on which I use the ReportViewer to call a Server Report. I fill the report viewer and I see the report correctly on the IE 7, however on the Firefox the Print button does not appear, only the refresh. On the .Net the printButton is set to visible, just on Firefox does not appear...any one had this issue?Thanks a lot for helping!

Our friends at microsoft have decided to make the print function an ActiveX control, supported only by IE

Reporting Job Queue

How does one print the detail content of a job in sql 2000?
Many thanks
ShahriarYou can script it from Enterprise Manager, for instance.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Shahriar" <HelloShahriar@.hotmail.com> wrote in message news:HTa3e.31986$uw6.27142@.trnddc06
..
> How does one print the detail content of a job in sql 2000?
> Many thanks
> Shahriar
>