TechNet
Products
IT Resources
Downloads
Training
Support
Products
Windows
Windows Server
System Center
Microsoft Edge
Office
Office 365
Exchange Server
SQL Server
SharePoint Products
Skype for Business
See all products »
Resources
Channel 9 Video
Evaluation Center
Learning Resources
Microsoft Tech Companion App
Microsoft Technical Communities
Microsoft Virtual Academy
Script Center
Server and Tools Blogs
TechNet Blogs
TechNet Flash Newsletter
TechNet Gallery
TechNet Library
TechNet Magazine
TechNet Wiki
Windows Sysinternals
Virtual Labs
Solutions
Networking
Cloud and Datacenter
Security
Virtualization
Updates
Service Packs
Security Bulletins
Windows Update
Trials
Windows Server 2016
System Center 2016
Windows 10 Enterprise
SQL Server 2016
See all trials »
Related Sites
Microsoft Download Center
Microsoft Evaluation Center
Drivers
Windows Sysinternals
TechNet Gallery
Training
Expert-led, virtual classes
Training Catalog
Class Locator
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
Microsoft Official Courses On-Demand
Certifications
Certification overview
Special offers
MCSE Cloud Platform and Infrastructure
MCSE: Mobility
MCSE: Data Management and Analytics
MCSE Productivity
Other resources
Microsoft Events
Exam Replay
Born To Learn blog
Find technical communities in your area
Azure training
Official Practice Tests
Support options
For business
For developers
For IT professionals
For technical support
Support offerings
More support
Microsoft Premier Online
TechNet Forums
MSDN Forums
Security Bulletins & Advisories
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums
Sign in
Home
Library
Wiki
Learn
Gallery
Downloads
Support
Forums
Blogs
Resources For IT Professionals
United States (English)
Россия (Pусский)
中国（简体中文）
Brasil (Português)
Skip to locale bar
Get this Tag RSS feed
Translate this page
Powered by
Microsoft® Translator
Popular Tags
Active Directory
AD
AD DS
adfs
ASP.NET
azure
BizTalk
BizTalk Server
BizTalk Server 2010
C#
Candidate for deletion
certification
cloud
core docs
de-DE
EAA
Ed Price
Ed's Stub Pages
en-US
ESA
es-ES
Excel
Exchange
Exchange 2010
fa-IR
Fernando Lugao Veltem
FIM
FIM 2010
FIM Resources
FIM-HELP
forefront
forums
fr-FR
Gokan Ozcifci
has code
has comment
has comments
has image
has Images
has Other Languages
has See Also
Has Table
Has TOC
Horizon_Net
How To
Hyper-V
id-ID
IIS
Italian Wiki Articles
it-IT
ja-JP
Jordano Mazzoni
Link Collection
Luciano Lima
Luigi Bruno
Lync Server 2010
MIISILMFIM MACAULAY
Multi Language Wiki Articles
needs work
operations manager
Pirated Content
Portal
Português Brasil
PowerShell
pt-BR
security
SharePoint
SharePoint 2010
SharePoint 2013
SharePoint Pirate
Small Basic
solucionando problemas
SQL Server
SQL Server 2012
stub
System Center
System Center 2012
TechNet Guru
TechNet Wiki
TechNet Wiki Featured Article
tonyso
Translated into Japanese
troubleshooting
tr-TR
vídeo
Video
Virtualization
VMM
Wiki
Windows
Windows 7
Windows 8
Windows Azure
Windows Server
Windows Server 2003
Windows Server 2008
Windows Server 2008 R2
Windows Server 2012
yottun8
اکتیو دایرکتوری
Browse by Tags
>
TechNet Articles
>
All Tags
>
ssrs
Tagged Content List
Wiki Page:
SQL Server Reporting Services - List of TechNet Wiki Articles
SathyanarrayananS
This article lists known TechNet Wiki articles about SQL Server Reporting Services . Table of Contents See Also SSRS (Matrix): How to Repeat Headers on Each Page and Keep Headers Fixed while Scrolling SSRS - RDL Compare SSRS: Multi-valued Parameter as Stored Procedure Input ...
on
21 Sep 2013
Wiki Page:
Using Claims Authentication across the Microsoft BI Stack
Heidi Steen - SQLUE
Applies to: SQL Server Analysis Services (SSAS), SQL Server Database Engine, SQL Server Reporting Services (SSRS), PowerPivot for SharePoint, SharePoint 2010 and 2013, Excel Services, PerformancePoint Services, Excel, PowerPivot for Excel, Power View This post is for Solution Architects who are...
on
18 Sep 2013
Wiki Page:
SQL Server 2012 Reporting Services (SSRS) Suggested Searches
Maheshkumar S Tiwari
In addition to finding information on the TechNet Wiki's SQL Server Reporting Services overview article review SQL Server Reporting Services (SSRS) Tech Center portal for SSRS information. This article also organizes Bing search results with resources for SQL Server 2012 Reporting...
on
17 Sep 2013
Wiki Page:
SSRS (Matrix): How to Repeat Headers on Each Page and Keep Headers Fixed while Scrolling
Naomi N
This article is an outcome of my answer to this question on MSDN SSRS forum . Previously I wrote similar article on SSRS: How to Repeat Headers on Each Page and keep headers fixed while scrolling for a table. In this article , let us see an example on how to repeat headers on each page and keep headers...
on
17 Sep 2013
Wiki Page:
SSRS: Multi-valued Parameter as Stored Procedure Input
Naomi N
Few months back I wrote an article on Multi-valued Parameter as Stored procedure Input, which will work only for single character multi-valued input parameter . Now let us see an example for SSRS report with Multi-valued Parameter as Stored procedure Input, which will work in all cases. ...
on
17 Sep 2013
Wiki Page:
SSRS: Troubleshoot Issues and Errors with Reporting Services
Carla Sabotta
Table of Contents Troubleshooting General Installation and Upgrade Configuration and Operations Samples Report Builder 3.0 SharePoint Integration and the SSRS SharePoint Add-In Report Server Report Manager See Also External Links Troubleshooting SQL Server 'Denali' Reporting Services...
on
13 Sep 2013
Wiki Page:
Must Declare Scalar Variable Error, in SSRS
Maheshkumar S Tiwari
There are various circumstances that may result in a "must declare the scalar variable" error when you try to run a report. If you know of other circumstances and the associated workarounds, please contribute this information to this article. Must Declare Scalar Variable Error...
on
13 Sep 2013
Wiki Page:
SSRS Troubleshooting: Report Builder does not work after you upgrade from SQL Server 2008 SP1 to SQL Server 2008 R2
Maheshkumar S Tiwari
Background: The default click-once version of Report Builder that will be used with SQL Server 2008 Reporting Services is Report Builder 1.0. If the Custom Report Builder Launch URL was modified to use Report Builder 2.0, then Report Builder may no longer work following an upgrade to SQL Server...
on
13 Sep 2013
Wiki Page:
SSRS: Multi Font Color / Multi Font Size within a Single Field / Textbox
TNJMAN
This article explains how to format the characters within a single Field or Textbox with varying font size and font color in SSRS. Consider the below code sample as the requisite dataset query: DECLARE @UnitsOfMeasurement TABLE (Measurement VARCHAR (50),Units VARCHAR (20)) ...
on
9 Sep 2013
Wiki Page:
Passing Comma Separated Values (SSRS - Multi-valued Parameter) as Input to Stored Procedure
Naomi N
In this post let us see how we can easily handle passing comma separated values as input to the stored procedure. This kind of situation generally happens when we design report with multi-valued input parameter which will be passed as input to the stored procedure. This code block has the sample...
on
9 Sep 2013
Wiki Page:
SQL Server Reporting Services
Carla Sabotta
Overview Microsoft SQL Server Reporting Services (SSRS) provides a complete, server-based platform designed to support a wide variety of reporting needs enabling organizations to deliver relevant information where needed across the entire enterprise. Reporting Services provides a...
on
6 Sep 2013
Wiki Page:
SSRS: How to Repeat Headers on Each Page
Maheshkumar S Tiwari
This article shows an example of how to repeat headers on each page of SSRS report . Consider this code block is my dataset query from AdventureWorks database: SELECT TOP 100 BusinessEntityID,JobTitle,Gender FROM [HumanResources].[Employee] Drag and drop Table from Toolbox...
on
5 Sep 2013
Wiki Page:
SSRS: Multiple Ways to Split a String into Multiple Lines
Ed Price - MSFT
This post is about how to split a string inside textbox or field into multiple lines . Below are the options to split a string into multiple lines : i.) using VBCRLF ii.) using chr(10) iii.) using <br> HTML tag Consider for example that I have a string "Microsoft Reporting...
on
5 Sep 2013
Wiki Page:
SSRS: How to Repeat Headers for Each Group
Ed Price - MSFT
This article is going to share the information on i) how to repeat headers for each group ii.) how to overcome this error: "An error occurred during local report processing . The definition of the report '/Report ' is invalid . The tablix 'Tablix' has a detailed member...
on
5 Sep 2013
Wiki Page:
SSRS: How to set Column Visibility Property for Many Columns Based on Parameter's Value
Ed Price - MSFT
This article is about setting Column Visibility property for many columns based on Parameter value. We can set Column Visibility property for Tablix/Matrix columns by selecting the column and then right-click - > Column Visibility - > Show or hide based on expression and then enter our custom...
on
5 Sep 2013
Wiki Page:
SSRS: How to Display Multiple Columns (Header and Value) Horizontally Stacked in one Row Cell
Ed Price - MSFT
This article is the outcome of my answer to this question in the MSDN SSRS forum . Example : Consider below query is my dataset : DECLARE @sample_data table ( Name varchar (50), AgeYears INT , WeightPounds INT , HeightInches INT ) insert...
on
5 Sep 2013
Wiki Page:
SSRS: How to Group Same Row Data with One Column Having Varying Data
Ed Price - MSFT
This article is the outcome of my answer to this question in the SSRS forum. Consider this sample data DECLARE @sample_data table ( [ Year ] varchar (5), Emp_id varchar (30), Name varchar (30), Accomplishments varchar (30) ) insert @sample_data...
on
5 Sep 2013
Wiki Page:
SSRS Report
Maheshkumar S Tiwari
Table of Contents Overview Power View Other Reporting Options See Also Overview SQL Server Reporting Services provides a full range of ready-to-use tools and services to help you create, deploy, and manage reports for your organization, as well as programming features that enable you to extend...
on
3 Sep 2013
Wiki Page:
Kerberos for Microsoft BI - With Delegation and SPN references for SQL, SSRS, SSAS, and SharePoint
Gokan Ozcifci
Here are the articles that can help with Kerberos, delegation, and getting Integrated Windows Authentication working with the Microsoft BI stack. What is the Microsoft BI stack? http://www.microsoft.com/bi lists SQL Server, SharePoint and Office as part of the Microsoft BI stack. Historically...
on
16 Aug 2013
Wiki Page:
SharePoint 2010: You Cannot See Reporting Services Icons After You Upgrade
Gokan Ozcifci
Table of Contents Background Workaround Applies to See Also Background Following the upgrade of a SharePoint environment to SharePoint 2010 Products, you may not be able to see the Reporting Services icons on several of the Web pages. For example, the document library context menu you see for...
on
16 Aug 2013
Wiki Page:
SharePoint 2013: SQL Server Reporting Services 2012 ile Bütünleşmesi (tr-TR)
Gokan Ozcifci
Merhabalar ÇözümPark ailesi, merhabalar SharePoint Kullanıcıları. SharePoint tarafından sıklıkça kullanılmakta olan bir konudan bahsetmek istiyorum: “SQL Server Reporting Services”. Bu günkü makalemde kullanmış olduğum yordamlar SharePoint modunda bir Reporting Services rapor sunucusu kurmanız için...
on
16 Aug 2013
Wiki Page:
SharePoint 2010: You See an Error Message About Insufficient Permssions When You Run a Report from a SharePoint Library
Gokan Ozcifci
Issue and Background When you try to view an SSRS report from a SharePoint library, you see the following error message: The permissions granted to user '[DOMAIN NAME]\[USER NAME] are insufficient for performing this operation. (rsAccessDenied) If you review the IIS Log you will...
on
16 Aug 2013
Wiki Page:
SharePoint 2010: SSRS Troubleshooting - You See an Error Message Regarding ContainerTypeNotSupported When You View a Report from a SharePoint Document Library
Gokan Ozcifci
Table of Contents Background Workaround Applies to See Also Background When you attempt to view a Reporting Services report in a SharePoint document library you see an error message that resembles the following: System.Web.Services.Protocols.SoapException: The target location you specified is...
on
16 Aug 2013
Wiki Page:
Reporting Services-specific Help Is Not Available from SharePoint Central Administration Pages
Gokan Ozcifci
Table of Contents Background Workaround Applies to See Also Background The Reporting Services Help page is not available from the SharePoint Help window on SharePoint Central Administration pages. Workaround Choose Site Settings . In Site Collection Administration , select Help Settings...
on
11 Aug 2013
Wiki Page:
SSRS Troubleshooting: Model Item Permissions Need to Be Updated
Gokan Ozcifci
Background: Reports based on report models will fail with errors indicating there are insufficient permissions to view the data source. Workaround: Open the right-click menu of the model and select the Manage Model Item Security properties page. Update the assigned permissions to an...
on
11 Aug 2013
Page 1 of 4 (83 items)
1
2
3
4
Can't find it? Write it!
Post an Article