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)
Found 92533 threads
-
0 VotesSSRS Expression: Using IIF / OR / AND
I am working with a report where I want to use an expression to control row visibility in Report Builder. The expression will determine if a name appears on a list or not. The conditions are as ...Answered | 1 Replies | 1805 Views | Created by IrishPod - Friday, August 14, 2020 9:34 PM | Last reply by IrishPod - Saturday, August 15, 2020 2:38 AM
-
0 Votes
SSRS Role ID and TaskMask
Hello, I need to find out who has access to what on SSRS. From the User table, I can query something like the following. ...Answered | 9 Replies | 12212 Views | Created by amNotAGeek - Saturday, August 28, 2010 3:43 PM | Last reply by GrangerATS - Friday, August 14, 2020 11:36 PM -
0 Votes
DYNAMIC TABLES AND COLUMNS WITH SSRS
Department Name userItems(dynamic) Sales Ram Phone ...Answered | 3 Replies | 1973 Views | Created by JaswanthKumar - Wednesday, August 12, 2020 5:47 PM | Last reply by JaswanthKumar - Friday, August 14, 2020 4:48 PM -
0 Votes
strategy for a report with lots of comments
hi we run 2016 enterprise. i'm looking at a report requirement that will be structured as follows. it would be tough to provide a ...Unanswered | 7 Replies | 1960 Views | Created by db042190 - Friday, August 7, 2020 5:02 PM | Last reply by Laxmidhar sahoo - Friday, August 14, 2020 3:28 PM -
2 Votes
Group Subtotal for Top N Values in SSRS 2008
Dear All, I am having one problem in calculating subtotal for the group filter to show top 2 values. Here is my requirement Date ...Answered | 16 Replies | 18703 Views | Created by Sathyalan - Tuesday, May 25, 2010 5:44 AM | Last reply by sarojas - Friday, August 14, 2020 2:46 PM -
1 Votes
Count Rows Of a filtered Tablix and show in a different Textbox (Outside Tablix)
> In Tablix took another hidden Cell (Let say Textbox_Test) and in expression wrote : countrow("Mytablix") >>In seperate textboxI am trying to refer that ...Answered | 13 Replies | 11769 Views | Created by Priya D - Wednesday, January 23, 2013 10:46 AM | Last reply by sarojas - Friday, August 14, 2020 1:30 PM -
0 Votes
Group on a new calculated field in a tablix
Hello everyone, I have a dataset within a Report where I calculate the count of the lines (values of a ...Proposed | 3 Replies | 1898 Views | Created by Markus Germany - Thursday, August 13, 2020 8:34 AM | Last reply by Zoehui-MSFT - Friday, August 14, 2020 7:26 AM -
0 Votes
SSRS - Date formatting and collapsing
Hello , I am fairly new to SSRS and my table data has a Regdate with year, month and day values( eg 2020, 01-Aug and 01-Aug-2020) I want to be ...Proposed | 2 Replies | 1302 Views | Created by SSRSNEwbier - Thursday, August 13, 2020 2:32 PM | Last reply by Olaf Helper - Friday, August 14, 2020 6:26 AM -
0 Votes
Read URL from SQL SERVER in SSRS
Hi All , i am new to SSRS and trying below to achieve I have table with column URL and Info as below. Both are set as nvarchar in SQL Server ( there may be ...Proposed | 3 Replies | 1714 Views | Created by Kartic21 - Monday, August 10, 2020 5:45 PM | Last reply by Joy_Zhao - Friday, August 14, 2020 3:52 AM -
0 Votes
Limit no of column and display the empty column at the last if no have data
Hi, I already refer to : ...Proposed | 2 Replies | 1643 Views | Created by Riannn - Monday, August 10, 2020 3:06 AM | Last reply by Joy_Zhao - Friday, August 14, 2020 3:50 AM -
0 Votes
SSRS 2014 Reports page cannot be displayed
I have setup the SSRS 2014 and am able to access the Web Service URL for the ReportServer but when I attempt to access the Report Manager URL (servername:80/Reports) I get the message "Page ...Proposed | 3 Replies | 1691 Views | Created by RachelWulff - Friday, August 7, 2020 7:00 PM | Last reply by Joy_Zhao - Friday, August 14, 2020 3:48 AM -
0 Votes
one aditional reporting services to SQL 2017
Hi to all, I have one SQL server 2017 with 6 instances and one reporting services running. Could I add one addition ...Answered | 6 Replies | 1638 Views | Created by MeVs - Wednesday, August 12, 2020 2:23 AM | Last reply by Zoehui-MSFT - Friday, August 14, 2020 1:21 AM -
0 Votes
Total of topN, total of other employees, total of all
I have a table which includes the columns Branch, Employee, Year, Sales and Revenue. I want to create a report which, for each branch, ranks the top N(parameter) employees by and the sum of their ...Proposed | 3 Replies | 1734 Views | Created by meddojeddo - Wednesday, August 12, 2020 5:06 AM | Last reply by Joy_Zhao - Thursday, August 13, 2020 8:24 AM -
0 Votes
setting 19 params without going to the well 19 times
hi we run 2016 enterprise. i have 19 parameters that can be set by selecting the top 1 row from one table using the value entered in the 20th parameter as a key to that ...Unanswered | 7 Replies | 1945 Views | Created by db042190 - Friday, August 7, 2020 9:37 PM | Last reply by Laxmidhar sahoo - Thursday, August 13, 2020 7:03 AM -
0 Votes
File links in SSRS reports
We have SSRS reports that create files in our central file stores. These file stores are secure internal SMB based \\servername\share locations. Internet Explorer 9, 10 and 11 all work ...Proposed | 5 Replies | 2507 Views | Created by gettnmorebetter - Thursday, August 6, 2020 11:25 PM | Last reply by Zoehui-MSFT - Thursday, August 13, 2020 6:26 AM -
0 Votes
Parameter mapping issue no records are returned in sql
Hi All, In my SQL for a report dataset I have a datetime variable declared: Declare @YTD datetime select @YTD=getdate() and ...Proposed | 3 Replies | 2005 Views | Created by NewBeeNewMe - Friday, August 7, 2020 7:32 PM | Last reply by Zoehui-MSFT - Thursday, August 13, 2020 2:06 AM -
0 Votes
how to deploy ssrs in internet
Hi everybody, I've developed some Power BI dashboards and published them to "power Bi Report Server" .now I want that the users be able to see the dashboards over ...Proposed | 2 Replies | 1278 Views | Created by mas sahar - Wednesday, August 12, 2020 9:14 AM | Last reply by Zoehui-MSFT - Thursday, August 13, 2020 1:48 AM -
0 Votes
/DataSets({Id})/Model.GetData SSRS Webapi 2.0 endpoint not returning the data..
Hi, I have been trying to consume the ssrs 2.0 web api endpoint -/DataSets({Id})/Model.GetData but it is throwing error ...Proposed | 5 Replies | 2730 Views | Created by Rahul Ranjan1988 - Monday, July 20, 2020 8:48 AM | Last reply by Rahul Ranjan1988 - Wednesday, August 12, 2020 12:53 PM -
0 Votes
How to get distinct value from a dataset column?
Hi, I have a column in data set,which contain different values. I want to extract distinct values from column in reporting services only (i.e without modifying my SP or SQL ...Answered | 3 Replies | 28444 Views | Created by Gagan Kr Sharma - Monday, December 21, 2009 3:49 AM | Last reply by Zbigniew Maćkiewicz - Wednesday, August 12, 2020 12:00 PM -
0 Votes
How to get full email address info for SSRS 2005 Subscriptions from database (query results are truncated)?
'2008-12-01' and (s.Description like '%Send e-mail to%' or LastStatus like '%Mail sent%') Thanks much!Answered | 2 Replies | 5300 Views | Created by equerystrian - Wednesday, October 21, 2009 10:07 PM | Last reply by shell_l_d - Tuesday, August 11, 2020 10:54 PM
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)
