Browse by Tags

Tagged Content List
  • Wiki Page: SQL Server Reporting Services - List of TechNet Wiki Articles

    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 ...
  • Wiki Page: Using Claims Authentication across the Microsoft BI Stack

    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...
  • Wiki Page: SQL Server 2012 Reporting Services (SSRS) Suggested Searches

    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...
  • Wiki Page: SSRS (Matrix): How to Repeat Headers on Each Page and Keep Headers Fixed while Scrolling

    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...
  • Wiki Page: SSRS: Multi-valued Parameter as Stored Procedure Input

    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. ...
  • Wiki Page: SSRS: Troubleshoot Issues and Errors with Reporting Services

    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...
  • Wiki Page: Must Declare Scalar Variable Error, in SSRS

    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...
  • Wiki Page: SSRS Troubleshooting: Report Builder does not work after you upgrade from SQL Server 2008 SP1 to SQL Server 2008 R2

    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...
  • Wiki Page: SSRS: Multi Font Color / Multi Font Size within a Single Field / Textbox

    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)) ...
  • Wiki Page: Passing Comma Separated Values (SSRS - Multi-valued Parameter) as Input to Stored Procedure

    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...
  • Wiki Page: SQL Server Reporting Services

    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...
  • Wiki Page: SSRS: How to Repeat Headers on Each Page

    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...
  • Wiki Page: SSRS: Multiple Ways to Split a String into Multiple Lines

    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...
  • Wiki Page: SSRS: How to Repeat Headers for Each Group

    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...
  • Wiki Page: SSRS: How to set Column Visibility Property for Many Columns Based on Parameter's Value

    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...
  • Wiki Page: SSRS: How to Display Multiple Columns (Header and Value) Horizontally Stacked in one Row Cell

    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...
  • Wiki Page: SSRS: How to Group Same Row Data with One Column Having Varying Data

    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...
  • Wiki Page: SSRS Report

    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...
  • Wiki Page: Kerberos for Microsoft BI - With Delegation and SPN references for SQL, SSRS, SSAS, and SharePoint

    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...
  • Wiki Page: SharePoint 2010: You Cannot See Reporting Services Icons After You Upgrade

    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...
  • Wiki Page: SharePoint 2013: SQL Server Reporting Services 2012 ile Bütünleşmesi (tr-TR)

    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...
  • Wiki Page: SharePoint 2010: You See an Error Message About Insufficient Permssions When You Run a Report from a SharePoint Library

    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...
  • Wiki Page: SharePoint 2010: SSRS Troubleshooting - You See an Error Message Regarding ContainerTypeNotSupported When You View a Report from a SharePoint Document Library

    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...
  • Wiki Page: Reporting Services-specific Help Is Not Available from SharePoint Central Administration Pages

    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...
  • Wiki Page: SSRS Troubleshooting: Model Item Permissions Need to Be Updated

    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...
Page 1 of 4 (83 items) 1234
Can't find it? Write it!