SQL Server Reporting Services
Report Server, Report Designer, Report Builder, and other reporting-related discussions.
Announcements
Reporting Services 2008 - Resources & Latest Downloads
Robert BrucknerMSFTThursday, February 05, 2009 9:44 PMLast update: July 22, 2010.
Get an overview and the latest information on Reporting Services 2008 at the MSDN aggregation page for Reporting Services!
Important downloads for Reporting Services 2008:
- Report Builder 2.0 (April 2009 Download) for Reporting Services 2008 (build 10.00.2531)
- SQL Server 2008 SP2 CTP (build 10.00.3798)
Note: SP2 CTP will upgrade to SP2 RTM.
- SQL Server 2008 SP1 Cumulative Update #9 (build 10.00.2789)
- SQL Server 2008 SP1 Cumulative Update #8 (build 10.00.2775)
- SQL Server 2008 SP1 Cumulative Update #7 (build 10.00.2766)
- SQL Server 2008 SP1 Cumulative Update #6 (build 10.00.2757)
- SQL Server 2008 SP1 Cumulative Update #5 (build 10.00.2746)
- SQL Server 2008 SP1 Cumulative Update #4 (build 10.00.2734)
- SQL Server 2008 SP1 Cumulative Update #3 (build 10.00.2723)
- SQL Server 2008 SP1 Cumulative Update #2 (build 10.00.2714)
- SQL Server 2008 SP1 Cumulative Update #1 (build 10.00.2710)
- SQL Server 2008 Service Pack 1 (build 10.00.2531)
- Updated RS Add-In for SharePoint Integrated Mode (build 10.00.2531)
- Note: updates for the SharePoint add-in are available for each CU as well, just make sure to select the "..._RSSharepoin" download package.
- SQL Server 2008 RTM Cumulative Update #10 (build 10.00.1835)
- SQL Server 2008 RTM Cumulative Update #9 (build 10.00.1828)
- SQL Server 2008 RTM Cumulative Update #8 (build 10.00.1823)
- SQL Server 2008 RTM Cumulative Update #7 (build 10.00.1818)
- SQL Server 2008 RTM Cumulative Update #6 (build 10.00.1812)
- SQL Server 2008 RTM Cumulative Update #5 (build 10.00.1806)
- SQL Server 2008 RTM Cumulative Update #4 (build 10.00.1798)
- SQL Server 2008 RTM Cumulative Update #3 (build 10.00.1787)
- SQL Server 2008 RTM Cumulative Update #2 (build 10.00.1779)
- SQL Server 2008 RTM Cumulative Update #1 (build 10.00.1763)
- SQL Server 2008 RTM (build 10.00.1600.22)
- Updated SQL Server 2008 Books Online (July 2009 Update)
Also check related discussion threads in this forum about the Reporting Services 2008 release, and Report Builder 2.0 release.- Report Builder 2.0 (April 2009 Download) for Reporting Services 2008 (build 10.00.2531)
Reporting Services 2005 - Resources & Latest Downloads
Robert BrucknerMSFTThursday, February 05, 2009 9:44 PMLast update: August 26, 2010.
MSDN information aggregator site for Reporting Services 2005.
Important downloads for Reporting Services 2005:
- SQL Server 2005 SP3 Cumulative Update #11 (build 9.00.4309)
- SQL Server 2005 SP3 Cumulative Update #10 (build 9.00.4305)
- SQL Server 2005 SP3 Cumulative Update #9 (build 9.00.4294)
- SQL Server 2005 SP3 Cumulative Update #8 (build 9.00.4285)
- SQL Server 2005 SP3 Cumulative Update #7 (build 9.00.4273)
- SQL Server 2005 SP3 Cumulative Update #6 (build 9.00.4266)
- SQL Server 2005 SP3 Cumulative Update #5 (build 9.00.4230)
- SQL Server 2005 SP3 Cumulative Update #4 (build 9.00.4226)
- SQL Server 2005 SP3 Cumulative Update #3 (build 9.00.4220)
- SQL Server 2005 SP3 Cumulative Update #2 (build 9.00.4211)
- SQL Server 2005 SP3 Cumulative Update #1 (build 9.00.4207)
- SQL Server 2005 SP3 RTM (build 9.00.4035)
- SQL Server 2005 SP2 Cumulative Update #17 (build 9.00.3356)
- SQL Server 2005 SP2 Cumulative Update #16 (build 9.00.3355)
- SQL Server 2005 SP2 Cumulative Update #15 (build 9.00.3330)
- SQL Server 2005 SP2 Cumulative Update #14 (build 9.00.3328)
- SQL Server 2005 SP2 Cumulative Update #13 (build 9.00.3325)
- SQL Server 2005 SP2 Cumulative Update #12 (build 9.00.3315)
- SQL Server 2005 SP2 Cumulative Update #11 (build 9.00.3301)
- SQL Server 2005 SP2 RTM (build 9.00.3042)
- RS Add-in for SharePoint Integrated Mode (SP3 download, SP2 download)
- SQL Server 2005 Books Online (December 2008 Update)
October 2009 GDI GDR for the Client Print Control, MS09-062.
Brad SyputaMSFTTuesday, October 13, 2009 11:32 PMClient Print control and GDI GDR MS09-062
On October 13th, Microsoft released a companywide update for all applications and operating systems that ship or redistribute GDIPlus.dll. SQL Server Reporting Services 2000 and 2005 redistributed GDI+ as part of the RSClientPrint.cab file Active X printing. In order to make this easier on our customers, we made several changes to help eliminate problems seen in the past.
1. GDIplus.dll has been removed from the RSClientPrint.cab for all versions of Reporting Services and the Report Viewer control. As a result, no future GDI+ updates will be required for Reporting Services or the Report Viewer control.
2. Because this vulnerability only manifested as a result of RSClientPrint.cab redistributing GDIPlus.dll for Windows 2000, we will only target the Killbit for that operating system. No other operating system will be impacted by the Killbit.
3. Blog post from Brian Hartman for more detailed explanation.
Impacted products:
SQL Server Reporting Services:
Reporting Services 2000 SP2
Reporting Services 2005 - All
Microsoft Report Viewer Control:
VS 2005 Report Control - All
VS 2008 – All
What do I need to do?
Apply the latest patches related to KB 957488 as you normally would for a Microsoft GDR. This will ensure that you are up to date with the latest software. As always, test patches in a none-production environment when possible before deploying.
Once your production environment is up to date, all client machines, when they print next, will install the latest RSClientPrint.cab. Depending on your environment and client settings, clients will be prompted or will install silently.
I updated my Report Server and now I cannot print. I know I am not using the Report Viewer control. What do I do?
In some rare cases on the client computer that is printing, a conflict will occur with the old and new controls. Uninstall the old control through Internet Explorer\Tools\Internet Options\Programs\Manage Add-ons.
I updated my Report Server and now I cannot print. I also have an application server hosting the Report Viewer control. What do I do?
Update the application server with the latest redistributable Report Viewer control for the version (2005 or 2008) that you have installed.
I subscribe to Microsoft Update. Is there going to be any problems?
Potentially yes. If your Application server and your Report Server are not updated at the same time, they will become out of sync and the Active X printing will no longer function. The fix is to update all systems. The Sharepoint add-in does not get updated by Microsoft Update.
My Report Server runs within Sharepoint. What do I do?
In the configuration of using Reporting Services with Sharepoint, you will need to update your Report Server with the latest patch and you will need to install the latest Sharepoint Add-in.
Reporting Services 2008 R2 - Resources & Latest Downloads
Robert BrucknerMSFTMonday, May 24, 2010 3:45 PMLast Update: August 26, 2010.
SQL Server 2008 R2 was released to manufacturing on April 21, 2010. You can read more about it here.
Downloads available:
- Report Builder 3.0 RTM
- SQL Server 2008 R2 RTM - Developer Trial Edition
- SQL Server 2008 R2 RTM - Express Edition with Advanced Services
- SQL Server 2008 R2 RTM - Documentation
- SQL Server 2008 R2 RTM - Feature Pack (with Report Builder and PowerPivot for Excel 2010)
- Reporting Services 2008 R2 Add-in for SharePoint 2010
- Visual Studio 2010 Report Viewer Redistributable
Cumulative Updates:
- SQL Server 2008 R2 RTM Cumulative Update #3 (build 10.50.1734)
- SQL Server 2008 R2 RTM Cumulative Update #2 (build 10.50.1720)
- SQL Server 2008 R2 RTM Cumulative Update #1 (build 10.50.1702)
You can read about specific new Reporting Services features added in November CTP on top of what was available in August CTP. You can research and ask questions on the dedicated MSDN forum.
** Please Include SSRS Version When Posting Questions
Sean BoonMSFTWednesday, April 22, 2009 4:45 AMWhen posting questions in this forum, please include the version of SQL Server Reporting Services you are using. This will help us be more efficient in answering questions. If you are using the Report Viewer Control, it will helpful if you include the version of the control as well.
Thanks,
Sean
Filtering and SortingUse these options to narrow down the question and discussion list.
- 3334737

SQL Server Reporting Services FAQ
Joe.WuMSFTThursday, April 23, 2009 10:25 AM - 06397

SQL Server Reporting Services FAQ, Mar 2010
sqlFans Friday, March 19, 2010 8:30 AM - 9202

SSRS permission problems
Chernobrivec Monday, September 06, 2010 3:01 PM - 387

Display current time (live?) on report?
CCusson15 22 hours 44 minutes ago - 013

Drilldown Causes Error: Invalid offset for item.
blackbirdway 1 hour 4 minutes ago - 117

no acces to http localhost reportserver. How to provide the access?
sebastian.mayer.67 1 hour 58 minutes ago - 385

Using multivalues parameter on sql where clause
VCHS Wednesday, September 08, 2010 1:34 PM - 2212

Schedule reports with integrated authentication SSRS 2008
Spud11 Wednesday, September 01, 2010 9:36 AM - 279

Dundas Map - Legend sort order
T.Bergvall Wednesday, September 08, 2010 6:13 AM - 7148

X-axis labels missing: SSRS 2005
Yash Ganthe Tuesday, September 07, 2010 9:28 AM - 5100

Format Datetime Parameter Label
richbrownesq Thursday, September 09, 2010 10:27 AM - 017

SQL 2008 External access returns wrong address for Report Manager
xesco 2 hours 58 minutes ago - 240

Run Reporting services 2005 with databases housed on SQL Server 2008?
Brent Willis 18 hours 49 minutes ago - 2105

Sum of Calulated field in a group error when containing a value $0
quacka Thursday, September 09, 2010 12:59 AM - 3138

For a Data-driven Subscription, If it Processes 20 but 2 error , how do i just run the ones that errored out?
tenchyz Thursday, September 02, 2010 4:32 PM - 275

SSRS Report Performance & Optimization
Farhan1 Wednesday, September 08, 2010 6:21 PM - 7196

Question on Custom Delivery Extension
Chetan Sarode Friday, September 03, 2010 4:26 AM - 6115

Report Format RDL Version Control
ASP808 Wednesday, September 08, 2010 6:53 PM - 164

Character spacing issue SSRS 2005 custom font
MMDevelop Wednesday, September 08, 2010 7:00 AM - 276

Passing multi values to another multi value parameter
RajeshPeethala Wednesday, September 08, 2010 8:09 PM