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 VotesError at iif with by zero division
0,iif(iif(isNothing(sum(Fields!VAL2.Value)), 0, sum(Fields!VAL2.Value)) > 0, (sum(Fields!VAL2.Value)/sum(Fields!VAL1.Value)), "error VAL2"), "error ...Proposed | 2 Replies | 108 Views | Created by Yerkhan - Thursday, October 17, 2019 11:59 AM | Last reply by nkumar230 - Thursday, October 17, 2019 1:37 PM
-
0 Votes
Format rows depending on toggle item possible?
Hi everyone, I have several reports which contain a lot of sums. Right now, it is a bit hard for the user to see at first glance which sum belongs to which element. Therefore I want ...Answered | 4 Replies | 155 Views | Created by pgosch - Wednesday, October 16, 2019 7:54 AM | Last reply by pgosch - Thursday, October 17, 2019 10:49 AM -
0 Votes
SSRS 2012 > 2017 migration, email subscriptions not working
We did our best to follow along with Microsoft's documentation for migrating SSRS servers ...Unanswered | 7 Replies | 403 Views | Created by ltwally1 - Friday, October 11, 2019 7:48 PM | Last reply by Zoe Gu - Thursday, October 17, 2019 6:56 AM -
0 Votes
SSRS Tooltip value in french
Hi, I want to display french rupees in tool-tip whether the report language is other than French. Any help would be greatly ...Proposed | 7 Replies | 592 Views | Created by Manisha K Chauhan - Thursday, August 22, 2019 12:14 PM | Last reply by Manisha K Chauhan - Thursday, October 17, 2019 6:10 AM -
0 Votes
Merge SSRS and PBIRS in one instance of PBIRS
Hello, I have an SSRS 2008 server and a Power BI Report Server. I need to unify the content of both servers in one. How can I do ...Proposed | 2 Replies | 142 Views | Created by rubenznho - Wednesday, October 16, 2019 12:40 PM | Last reply by Lukas DreiKlein - Thursday, October 17, 2019 2:52 AM -
0 Votes
Slow Response Times Loading SSRS Report Via Portal
We are in the process of migrating from SQL Server 2008 Reporting services to SQL Server 2016 Reporting services. All the 2008 reports have been downloaded from 2008 and then ...Proposed | 3 Replies | 252 Views | Created by Jocelyn N B McCarthy - Thursday, October 10, 2019 2:09 PM | Last reply by Lukas DreiKlein - Thursday, October 17, 2019 2:46 AM -
4 Votes
Error: Subreport could not be shown.
I have a problem with a report containing a subreport not running successfully when deployed to the Report Server. The report runs successfully every time in the VS Development ...Answered | 17 Replies | 59140 Views | Created by Mina N - Saturday, September 3, 2011 9:27 AM | Last reply by Ameryl - Thursday, October 17, 2019 12:44 AM -
0 Votes
SSRS Filter not filtering correctly
I pass a parameter UserID in SQL and have a dataset with the unique UserIDs.The dataset uses the userids to display the usernames. Now when I run the report and choose ...Proposed | 3 Replies | 573 Views | Created by Saanah - Tuesday, July 30, 2019 12:44 PM | Last reply by Saanah - Wednesday, October 16, 2019 7:51 PM -
0 Votes
how to show a compressed image in the report?
Hi I have created a new report.what i do in application is i compress the image and save it in database.now i need to retrieve the compressed image and display in the report. ...Answered | 5 Replies | 3341 Views | Created by Manoj kumar A - Friday, September 14, 2012 10:15 AM | Last reply by Paul Timofti - Wednesday, October 16, 2019 7:23 PM -
0 Votes
Negative zero formatting
Hi All, What number format I should use to get below output 32.383 - 32.881 = -0.49799 I would like to show -0.49799 as ...Answered | 5 Replies | 232 Views | Created by AshokKOjha - Tuesday, October 15, 2019 7:34 PM | Last reply by AshokKOjha - Wednesday, October 16, 2019 6:29 PM -
0 Votes
Report for non-interactive display monitor with more than one page.
I am creating a report for a non-interactive display monitor. The problem is the report has more than one page or screen view of data so you can only see the first page or screen view. I ...Answered | 2 Replies | 341 Views | Created by MESfred - Wednesday, September 11, 2019 12:05 PM | Last reply by MESfred - Wednesday, October 16, 2019 3:29 PM -
0 Votes
Troubleshooting the Mobile Reports error: Could not load mobile report - The report may be misconfigured, the data may not be available, or the server version may be unsupported.
My customer is seeing this error when viewing a mobile report: Could not load mobile report - The report may be misconfigured, the data may not be available, or the server version ...Unanswered | 11 Replies | 2935 Views | Created by Gregory Block, PhD - Monday, December 19, 2016 8:51 PM | Last reply by Gregory Block - Wednesday, October 16, 2019 1:08 PM -
0 Votes
Click into report error
I created the function to "go to the report" for a field like the image below. That report works fine when I run it on the server. If it has to be an ip: port for the ...Proposed | 3 Replies | 167 Views | Created by Studyandshare - Wednesday, October 16, 2019 11:24 AM | Last reply by Studyandshare - Wednesday, October 16, 2019 12:59 PM -
0 Votes
Developer SQL but SSRS has expired?
We have Developer SQL - yes, it show as that in SSMS - and so we SHOULD have SSRS as well, correct? Unfortunately, it (SSRS) quietly expired on us. Everyone keeps telling us ...Proposed | 2 Replies | 161 Views | Created by CBatBC - Tuesday, October 15, 2019 6:02 PM | Last reply by Olaf Helper - Wednesday, October 16, 2019 8:33 AM -
0 Votes
SSRS Using command to get data-driven report parameters
We're migrating SSRS reports (created from SQL Server 2008 R2) to Azure now. In data-driven subscription settings, only "query" is supported to get report ...Answered | 2 Replies | 241 Views | Created by Nick_Go - Monday, October 14, 2019 10:05 AM | Last reply by Nick_Go - Wednesday, October 16, 2019 8:31 AM -
0 Votes
.rdl file is not supporting on Visual Studio 2016
Hi i have .rdl file for SSRS report i used to work on Visual Studio 2012. i have upgraded my system to windows 10 and i have Visual Studio 2016. My old .rdl file is coming ...Unanswered | 2 Replies | 203 Views | Created by DG20 - Tuesday, October 15, 2019 3:25 PM | Last reply by Olaf Helper - Wednesday, October 16, 2019 7:49 AM -
0 Votes
SSRS Report Builder
Hi My requirement is when I pass Report language "en-us" format currency will be display in French currency format ...Proposed | 3 Replies | 215 Views | Created by Bhakti Lad - Monday, October 14, 2019 7:13 AM | Last reply by Lukas DreiKlein - Wednesday, October 16, 2019 6:18 AM -
3 Votes
Always refreshing a report parameters - SSRS 2014-2016
Hi, I've a SSRS 2014 report with an only parameter and a dataset that calls a stored procedure. I've set the "Always refresh" option for the report ...Unanswered | 7 Replies | 196 Views | Created by pscorca - Tuesday, October 15, 2019 10:40 AM | Last reply by Zoe Gu - Wednesday, October 16, 2019 5:40 AM -
0 Votes
Layout of more than 3 chart areas
I need to display 5 different chart areas in a top-down layout. The first 3 chart areas layout as expected. However, once I add a 4th area, it starts to layout more like a ...Answered | 3 Replies | 199 Views | Created by uler3161 - Wednesday, October 16, 2019 2:37 AM | Last reply by Lukas DreiKlein - Wednesday, October 16, 2019 5:34 AM -
0 Votes
Populate PDF properties subject line
How do you export an RDL to PDF and populate the document properties subject line with a report parameters value?Proposed | 4 Replies | 337 Views | Created by LopakaBarnes - Saturday, October 12, 2019 4:07 AM | Last reply by Lukas DreiKlein - Wednesday, October 16, 2019 3:24 AM
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)
