SQL Server Reporting Services, Power View announcement
-
Link
We have released a beta version of the Reporting Services Migration Tool. The tool is available for download at:
http://www.microsoft.com/download/en/details.aspx?id=29560
This tool essentially allows you to create a backup store of a native mode Report Server and then migrate that content to a SharePoint-integrated mode Report Server. Migrated content includes all report items (reports, shared data sources, models, shared datasets, report parts), along with associated metadata (shared schedules, subscriptions, history snapshots, etc.). Some additional details are in this blog post, along with the download link:
http://blogs.msdn.com/b/jameswu/archive/2012/04/21/reporting-services-migration-tool.aspx
We are working on enabling more features in this tool, so feel free to share any feedback or report any issues. Thanks!
-
Link
Last Update: Mar 4, 2011.
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 #6 (build 10.50.1765)
-
SQL Server 2008 R2 RTM Cumulative Update #5 (build 10.50.1753)
- SQL Server 2008 R2 RTM Cumulative Update #4 (build 10.50.1746)
- 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.
-
Link
When 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 -
Link
Last update: Mar 27, 2011.
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:
SP2:
- Report Builder 2.0 (SP2 Download)
for Reporting Services 2008 (build 10.00.4000)
- SQL Server 2008 SP2 Cumulative Update #3 (build 10.00.4279)
- SQL Server 2008 SP2 Cumulative Update #2 (build 10.00.4272)
- SQL Server 2008 SP2 Cumulative Update #1 (build 10.00.4266)
- Download SQL Server 2008 SP2
- Download SQL Server 2008 SP2 Express
- Download SQL Server 2008 SP2 Feature Packs
- RS 2008 SP2 Add-In for SharePoint Integrated Mode (build 10.00.4000)
Note: updates for the SharePoint add-in are available for each CU as well, just make sure to select the "..._RSSharepoin" download package.
SP1:
- RS 2008 SP1 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 SP1 Cumulative Update #13 (build 10.00.2816)
- SQL Server 2008 SP1 Cumulative Update #12 (build 10.00.2808)
- SQL Server 2008 SP1 Cumulative Update #11 (build 10.00.2804)
- SQL Server 2008 SP1 Cumulative Update #10 (build 10.00.2799)
- 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)
RTM:
- 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 (SP2 Download)
-
Link
Last update: Mar 27, 2011.
MSDN information aggregator site for Reporting Services 2005.
Important downloads for Reporting Services 2005:
SP4:
- SQL Server 2005 SP4 Cumulative Update #3 (build 9.00.5266)
- SQL Server 2005 SP4 Cumulative Update #2 (build 9.00.5259)
- SQL Server 2005 SP4 Cumulative Update #1 (build 9.00.5254)
- SQL Server 2005 SP4 RTM, Express Edition RTM (build 9.00.5000)
SP3:
- SQL Server 2005 SP3 Cumulative Update #15 (build 9.00.4325)
- SQL Server 2005 SP3 Cumulative Update #14 (build 9.00.4317)
- SQL Server 2005 SP3 Cumulative Update #13 (build 9.00.4315)
- SQL Server 2005 SP3 Cumulative Update #12 (build 9.00.4311)
- 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)
SP2:
- SQL Server 2005 SP2 Cumulative Update #17 (build 9.00.3356) - Final CU for SP2
- 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)
-
0 VotesReporting service configuration connection not connecting server
Hi all, When I trying to connect ssrs: How to fix this? thanks.Unanswered | 5 Replies | 137 Views | Created by SamDany - Thursday, December 26, 2019 8:41 AM | Last reply by jeffw8713 - 9 hours 49 minutes ago -
0 VotesSSRS Render MHTML to Email - Interactive & Tabs
Hi, SSRS Render MHTML to Email - Interactive & Tabs 1. Interactive - I would like to build a matrix type with expand & collapse icons with a ...Unanswered | 2 Replies | 116 Views | Created by Ismailc1 - Thursday, December 26, 2019 9:20 AM | Last reply by Ismailc1 - 12 hours 53 minutes ago -
0 VotesConfused with terminology on Reporting Services. Need clarity
New => Project and here there is a diversion from what this Lesson 1 tells me. The only option that my VS2017 offers me is "Reports App." Lesson 1 says I could find "Report ...Unanswered | 3 Replies | 298 Views | Created by MyCatAlex - Sunday, December 22, 2019 6:20 PM | Last reply by MyCatAlex - Friday, December 27, 2019 5:07 PM -
0 VotesI need to get the data for first 5 days and 6-10 days between created date and current date
= @startdate and createdate -
0 VotesSumming the dynamic column values in a row in a matrix
In the above screenshot, columns HR,IT,SUPPORT,FINANCE are dynamic(there might be few more columns). I'm able to get the total of each department (i.e. 6,10,6,10) and the total of ...Proposed | 2 Replies | 392 Views | Created by BhanuGadi - Wednesday, December 18, 2019 10:38 AM | Last reply by BhanuGadi - Friday, December 27, 2019 10:01 AM -
0 VotesSSRS certificate binding issue
I'm running SQL 2016 standard with SSRS in SCCM/ConfMgr server. I have AD CA in use and I'm transforming this server entirely to https use. With SSRS, I have a 2 ...Unanswered | 9 Replies | 798 Views | Created by Pavel yannara Mirochnitchenko - Tuesday, December 17, 2019 7:59 PM | Last reply by Pavel yannara Mirochnitchenko - Friday, December 27, 2019 9:19 AM -
0 VotesControl Page Breaks
Hi, I have a master report where I am calling many sub reports. I am rendering them in PDF format. Based on data populating within a sub report, sometime one sub report is consuming ...Unanswered | 2 Replies | 92 Views | Created by Zeeshan Shani - Thursday, December 26, 2019 5:30 PM | Last reply by Zeeshan Shani - Friday, December 27, 2019 8:54 AM -
0 Votespage footer issue
Hi, The report has headers and footers The first page of the report is the cover page in which the footer and header is hidden using an expression in the hidden ...Proposed | 8 Replies | 664 Views | Created by arkiboys - Wednesday, December 18, 2019 3:32 PM | Last reply by arkiboys - Friday, December 27, 2019 8:19 AM -
0 VotesSSRS 2016 error creating/modify subscription
we have 12 report in this server, we have issue on particular report while add/modify supscription. the SSRS reporting server is throwing an error when trying to ...Unanswered | 1 Replies | 67 Views | Created by KIRUBAKARAN J A - Friday, December 27, 2019 5:32 AM | Last reply by Lukas DreiKlein - Friday, December 27, 2019 7:58 AM -
0 Votes“No response” when viewing a report in the web server
Hi Guys, I have a website(ASP.Net, targeting on .Net Framework 4.7.2) and it is hosted a web server, IIS 10 in a Windows Server ... -
0 VotesGetting error when creating virtual directory : Microsoft.ReportingServices.WmiProvider.WMIProviderException: The virtual directory specified is not valid.
System.Runtime.InteropServices.COMException (0x8004020D): Cannot modify or delete an object that was not added using the COM+ Admin SDK (Exception from HRESULT: 0x8004020D) ...Unanswered | 5 Replies | 420 Views | Created by Anil Saran - Friday, December 20, 2019 10:43 AM | Last reply by Anil Saran - Friday, December 27, 2019 3:56 AM -
0 VotesReport server not initialised, cannot backup encryption keys - I want to uninstall and reinstall
Not sure if I'm asking in the correct place, but here goes. A quick overview: I'm trying to install MS Azure backup server, but this is failing, stating that it ...Unanswered | 6 Replies | 957 Views | Created by AmandaJayne - Thursday, December 5, 2019 11:26 AM | Last reply by Lukas DreiKlein - Friday, December 27, 2019 2:55 AM -
0 VotesError: The RPC server is not listening for PBIRS - Works with SSRS
System.Runtime.InteropServices.COMException: The RPC server is not listening. (Exception from HRESULT: 0x800706B3) --- End of inner exception stack trace ...Unanswered | 3 Replies | 362 Views | Created by --Tobias-- - Friday, December 20, 2019 2:58 PM | Last reply by Lukas DreiKlein - Friday, December 27, 2019 2:34 AM -
0 VotesDebugging Expressions for Parameters
I am using SSRS 2016. I have two parameters (A & P) on a report that depend on the value of another parameter (hType). The expressions are identical however the expression in ...Unanswered | 5 Replies | 770 Views | Created by Ulysses B Brown Jr - Wednesday, December 18, 2019 8:35 PM | Last reply by Lukas DreiKlein - Friday, December 27, 2019 2:27 AM -
0 VotesSSRS saving report to Word doc, changes font to 1pt.
We have a problem that appears to be connected to saving a SQL report as a Word document. Both Visual Studio and SSRS change the font style to Times New Roman (instead of Tahoma) and ...Unanswered | 3 Replies | 426 Views | Created by Greg2327 - Thursday, December 19, 2019 7:48 PM | Last reply by Lukas DreiKlein - Friday, December 27, 2019 2:23 AM -
0 VotesIssue while Converting Date/Time values according to a timezone in SSRS using CRM Online
Hi, The below stated is the problem we faced in SSRS report which shows incorrect data and the reason is the time zone difference between the user and the ...Proposed | 3 Replies | 496 Views | Created by Sandip_Patel_Cloudfronts - Tuesday, December 17, 2019 6:54 AM | Last reply by Lukas DreiKlein - Friday, December 27, 2019 2:16 AM -
0 VotesIssue with rs.exe.
Microsoft.ReportingServices.Di agnostics.Utilities.WrongItemTypeException: The operation you are attempting on item 'ssrsURL/bi/reporting services' is not ...Unanswered | 5 Replies | 607 Views | Created by ChrisRDBA - Thursday, December 19, 2019 9:54 PM | Last reply by ChrisRDBA - Thursday, December 26, 2019 8:59 PM -
0 VotesDate is not refreshing based on the Combo value in SSRS
I have a SSRS report with following fields: 1. Season. 2. Start Date 3. End ...Answered | 2 Replies | 1723 Views | Created by bmsqldev - Tuesday, February 9, 2016 1:43 PM | Last reply by RandonEliason - Thursday, December 26, 2019 5:23 PM -
0 VotesHow to Make simple timeline using 3 date fields from same record using names as labels
Hi, Hoping this would be an easy one for someone to answer: Given the following data set: (each record contains) ProjectID (Text) , ...Proposed | 5 Replies | 498 Views | Created by Ibis Ripley - Wednesday, December 18, 2019 4:59 PM | Last reply by DJAdan - Thursday, December 26, 2019 4:52 PM -
0 VotesSSRS date expression based on another expression
I am building a report for employee milestone anniversaries. I want to pull data for the 'next' month, but for 5, 10, 15, 20, 25 years back. (ex: In Dec 2019, in preparation for the ...Proposed | 1 Replies | 102 Views | Created by cmeurrens - Thursday, December 26, 2019 2:34 PM | Last reply by DJAdan - Thursday, December 26, 2019 4:18 PM - Items 1 to 20 of 91784 Next ›
SQL Server Reporting Services, Power View announcement
-
Link
We have released a beta version of the Reporting Services Migration Tool. The tool is available for download at:
http://www.microsoft.com/download/en/details.aspx?id=29560
This tool essentially allows you to create a backup store of a native mode Report Server and then migrate that content to a SharePoint-integrated mode Report Server. Migrated content includes all report items (reports, shared data sources, models, shared datasets, report parts), along with associated metadata (shared schedules, subscriptions, history snapshots, etc.). Some additional details are in this blog post, along with the download link:
http://blogs.msdn.com/b/jameswu/archive/2012/04/21/reporting-services-migration-tool.aspx
We are working on enabling more features in this tool, so feel free to share any feedback or report any issues. Thanks!
-
Link
Last Update: Mar 4, 2011.
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 #6 (build 10.50.1765)
-
SQL Server 2008 R2 RTM Cumulative Update #5 (build 10.50.1753)
- SQL Server 2008 R2 RTM Cumulative Update #4 (build 10.50.1746)
- 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.
-
Link
When 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 -
Link
Last update: Mar 27, 2011.
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:
SP2:
- Report Builder 2.0 (SP2 Download)
for Reporting Services 2008 (build 10.00.4000)
- SQL Server 2008 SP2 Cumulative Update #3 (build 10.00.4279)
- SQL Server 2008 SP2 Cumulative Update #2 (build 10.00.4272)
- SQL Server 2008 SP2 Cumulative Update #1 (build 10.00.4266)
- Download SQL Server 2008 SP2
- Download SQL Server 2008 SP2 Express
- Download SQL Server 2008 SP2 Feature Packs
- RS 2008 SP2 Add-In for SharePoint Integrated Mode (build 10.00.4000)
Note: updates for the SharePoint add-in are available for each CU as well, just make sure to select the "..._RSSharepoin" download package.
SP1:
- RS 2008 SP1 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 SP1 Cumulative Update #13 (build 10.00.2816)
- SQL Server 2008 SP1 Cumulative Update #12 (build 10.00.2808)
- SQL Server 2008 SP1 Cumulative Update #11 (build 10.00.2804)
- SQL Server 2008 SP1 Cumulative Update #10 (build 10.00.2799)
- 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)
RTM:
- 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 (SP2 Download)
-
Link
Last update: Mar 27, 2011.
MSDN information aggregator site for Reporting Services 2005.
Important downloads for Reporting Services 2005:
SP4:
- SQL Server 2005 SP4 Cumulative Update #3 (build 9.00.5266)
- SQL Server 2005 SP4 Cumulative Update #2 (build 9.00.5259)
- SQL Server 2005 SP4 Cumulative Update #1 (build 9.00.5254)
- SQL Server 2005 SP4 RTM, Express Edition RTM (build 9.00.5000)
SP3:
- SQL Server 2005 SP3 Cumulative Update #15 (build 9.00.4325)
- SQL Server 2005 SP3 Cumulative Update #14 (build 9.00.4317)
- SQL Server 2005 SP3 Cumulative Update #13 (build 9.00.4315)
- SQL Server 2005 SP3 Cumulative Update #12 (build 9.00.4311)
- 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)
SP2:
- SQL Server 2005 SP2 Cumulative Update #17 (build 9.00.3356) - Final CU for SP2
- 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)
