Browse by Tags

Tagged Content List

Wiki Page: SQL Server 2012 Reporting Services Native Mode Configuration

Richard Mueller

If SQL Server Reporting Services (SSRS) is setup in Native mode along with SQL Server database engine, the configuration is automatically done and SSRS is ready for use. SSRS Setup options can be reviewed at http://social.technet.microsoft.com/wiki/contents/articles/15183.sql-server-2012-reporting...

on12 Apr 2013
Wiki Page: SQL Server Reporting Services Scale-out in Native mode

VijayReports [MSFT]

Here are a list of references for those interested in setting up and configuring a SQL Server Reporting Services (SSRS) native mode instance in scale-out mode. Concepts Involved Let's start by confirming an oft repeated warning - Reporting Services is not cluster-aware . High Availability...

on8 Apr 2013
Wiki Page: Power View FAQ, Troubleshooting, Tips, and Tricks

maggiesMSFT

This topic has been retired. For Power View design tips, see Power View basic design tasks .

on5 Apr 2013
Wiki Page: SQL Server 2012 Reporting Services Tips, Tricks, and Troubleshooting

KCRyan318

Table of Contents Other Resources Using an Older Version of ReportViewer with SQL Azure Reporting Issue: Workaround: Troubleshoot Installation and Upgrade Issues with SQL Server 2012 SharePoint Mode Issues You do not see the SQL Server Reporting Services Service in SharePoint Central Administration after...

on11 Mar 2013
Wiki Page: Down Memory Lane with major changes in SQL Server Reporting Services

VijayReports [MSFT]

Having supported all versions from SQL Server 2000 Reporting Services to SQL Server 2012 Reporting Services , and preparing to support Windows Azure SQL Reporting thought it would be a nice time to look at how it has changed over this time. SQL Server 2000 Reporting Services SQL Server...

on7 Mar 2013
Wiki Page: Project Crescent Design Experience

Ed Price - MSFT

The content in this topic was for Project Crescent, the code name in Microsoft SQL Server Code-Named “Denali”, Community Technology Preview 3 (CTP 3). Power View is the new name for Project Crescent in Microsoft SQL Server 2012 Release Candidate 0 (RC0). Important: Most Power View documentation...

on2 Mar 2013
Wiki Page: System Requirements for Project Crescent

Ed Price - MSFT

The content in this topic was for Project Crescent, the code name in Microsoft SQL Server Code-Named “Denali”, Community Technology Preview 3 (CTP 3). Power View is the new name for Project Crescent in Microsoft SQL Server 2012 Release Candidate 0 (RC0). Important: Most Power View documentation...

on2 Mar 2013
Wiki Page: Create and Save Project Crescent Reports in SharePoint

Ed Price - MSFT

The content in this topic was for Project Crescent, the code name in Microsoft SQL Server Code-Named “Denali”, Community Technology Preview 3 (CTP 3). Power View is the new name for Project Crescent in Microsoft SQL Server 2012 Release Candidate 0 (RC0). Important: Most Power View documentation...

on2 Mar 2013
Wiki Page: Power View Overview

Ed Price - MSFT

This is the TechNet Wiki page for Power View, a feature of Microsoft SQL Server 2012 Reporting Services Add-in for Microsoft SharePoint Server 2010 Enterprise Edition. Power View is an interactive data exploration, visualization, and presentation experience. Important: Please visit Power ...

on2 Mar 2013
Wiki Page: Find ESRI Shapefiles for a SQL Server 2008 R2 Reporting Services Map (SSRS)

Richard Mueller

ESRI shapefiles contain data that complies with the Environmental Systems Research Institute, Inc. (ESRI) shapefile spatial data format. ESRI shapefiles are available on the Web from a variety of sites. The term "shapefile" applies to a set of related files. To add a map to a report, you...

on1 Mar 2013
Wiki Page: Tutorial: Create Charts, Tiles, and Other Visualizations in Project Crescent

Yagmoth555

In this tutorial for Project Crescent , you create tables and convert them into a number of different visualizations. You create tiles and add visualizations to them. You create a bubble chart and add a play axis to it, so you can see how the values change over time. You create small multiples –...

on20 Feb 2013
Wiki Page: Filtering, Highlighting, and Slicers in Project Crescent

Yagmoth555

The content in this topic was for Project Crescent, the code name in Microsoft SQL Server Code-Named “Denali”, Community Technology Preview 3 (CTP 3). Power View is the new name for Project Crescent in Microsoft SQL Server 2012 Release Candidate 0 (RC0). Important: Most Power View documentation...

on19 Feb 2013
Wiki Page: SQL Server Code-Named "Denali" CTP1 Release Notes

Ed Price - MSFT

This page is carefully and closely monitored. Any changes you make will be evaluated and then quickly accepted, refined, or reverted. Because this is a wiki, additions or refinements to these release notes might have been made by community members. To read the original release notes document, click here...

on15 Feb 2013
Wiki Page: Troubleshoot SQL Server 2008 R2 Reporting Services AdventureWorks Sample Reports (SQL Server Reporting Services SSRS)

Ed Price - MSFT

Table of Contents Issue View Reports Successfully Your Reporting Services Reports Displays Different or No Data Showcase Localized Data in Reports Issue The SQL Server 2008 R2 Reporting Services (SSRS) AdventureWorks sample reports do not run and you receive the message “Cannot create a connection...

on15 Feb 2013
Wiki Page: SQL Server Reporting Services in SharePoint Integrated mode

VijayReports [MSFT]

Here are a list of references for those interested in setting up, configuring, operating and managing a SQL Server Reporting Services (SSRS) instance in SharePoint integrated mode. If there's any area needing more attention or references, please add those topics to the comments below. Thanks for...

on31 Dec 2012
Wiki Page: Searching for SQL Server 2008 Reporting Services (SSRS)

VijayReports [MSFT]

In addition to finding information on the TechNet Wiki's SQL Server Reporting Services overview article , Look on our SQL Server Reporting Services (SSRS) Tech Center portal for SSRS information. This article also organizes Bing search results with resources for SQL Server 2008 Reporting Services...

on28 Dec 2012
Wiki Page: SSRS 2008 R2 Atom Data Feeds for PowerPivot

TK MAHATO

This article focuses on a new feature of SQL Server Reporting Services 2008 R2: enabling data feeds to be exported from a report and consumed in the new SQL 2008 R2 PowerPivot client. With the release of SSRS 2008 R2, we now have a new rendering extension to render Atom data feeds from SSRS reports...

on24 Dec 2012
Wiki Page: Uninstalling a Service Pack or Cumulative Update Causes Requests to a Report Server and Report Manager to Fail (SSRS)

Fernando Lugão Veltem

Table of Contents Background Workaround if you have a backup of the report server symmetric key Workaround if you do not have a backup of the report server symmetric key Applies to More Information Background Uninstalling a Service Pack or Cumulative Update causes requests to Report Server...

on26 Aug 2012
Wiki Page: SSRS Troubleshooting: You Receive an InvalidDataSourceCredentialSettingException When You Attempt to Test Connection on a SharePoint List Data Source

Fernando Lugão Veltem

Table of Contents Background: Workaround: Applies to: See Also Background: When you attempt to click the Test Connection button on a data source that is configured to use the SharePoint List data source type, you see an error message that resembles the following: Microsoft.ReportingServices...

on26 Aug 2012
Wiki Page: SQL Server Reporting Services 2008 R2 : Print Control Requires Embedded IFrame for Modal Dialogs

Chaitanya Medikonduri

Issue: Internet Explorer modal dialogs require IFrames to access the WebBrowser COM interface. SQL Server 2008 R2 changed from using IFrames to AJAX update panels. If you launch SQL Server 2008 R2 report using the IE modal dialog, and try to print the report using the print option on the report, then...

on11 Jul 2012
Wiki Page: Deploy Windows Azure SQL Reporting on an On-Premise SQL Server Reporting Service

patmas57

There is bug in Windows Azure SQL Reporting Services CTP where reports that take longer than 1 minute to execute are being killed by Windows Azure as "idle connections", see http://social.msdn.microsoft.com/Forums/en-US/ssdsgetstarted/thread/9d43af1a-0100-4f4c-9166-9702776d0d43/ Most...

on3 Jul 2012
Wiki Page: ConfigMgr (SCCM) – SQL Server Reporting Service (SSRS) – Error Timeout Expired

Anoop C Nair

Recently, I was working on SQL server Reporting Service issue and I thought of documenting it so that (may be ) it will helpful to someone !!! Latest Updated Link - http://anoopcnair.com/2011/07/20/configmgr-sccm-sql-server-reporting-service-timeout-expired/ See, the error message An error...

on26 Jun 2012
Wiki Page: SSRS - IIF function evaluates both True & False

Sorna Kumar Muthuraj

In recent past , i have seen multiple questions in forums around the IIF function is evaluating both True & False even the given condition is not satified. Yes , By design the SSRS evaluates both True & False statments even though the condition is not satified and through error if something...

on18 Jun 2012
Wiki Page: Percentage of Actual VS Target

Syed Qazafi Anjum

Hi All Recently I have been involved lot of time to answer on the SSRS forum how to take percentage of actual value against a total or target value and lot of people are facing problem by having a result as #error message some time NAN and some time it come as infinity. I thought it would be good...

on11 Jun 2012
Wiki Page: SharePoint 2010: SSRS Infrastructure (Reporting Services Integrated Mode)

Craig Lussier

SSRS A frequently asked question is what the SSRS infrastructure looks like in SharePoint integrated mode. Well, like this: On the clients: rich clients optionally leverage the ReportViewer Windows Forms control, ASP.NET pages use the ASP.NET ReportViewer Web control. On each SharePoint WFE...

on7 Mar 2012