Browse by Tags

Tagged Content List

Wiki Page: Cache Refreshing in SQL Server Reporting services

Maheshkumar S Tiwari

The ability to configure caching for reports has been available in every release of Reporting Services. This feature is helpful in situations in which reports take a long time to execute and the source data is not in a constant state of change. By storing the report in cache, Reporting Services can...

on3 Sep 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...

on16 Aug 2013
Wiki Page: Using Custom Code in SSRS Reports for Advanced String Operations

Carsten Siemens

Overview SQL Services Reporting Services is a very powerful tool and with each new release, it grows in functionality. However many users find that the expression builder functions do not quite do what they need. Fortunately, Microsoft has provided a powerful means of extending the capabilities...

on3 Aug 2013
Wiki Page: Concatenating Data Column Values Into a Single String

SathyanarrayananS

The Request My dataset returns multiple rows of data for a given grouping with only one field (we will call it Grade) varying across those rows. I want my report to display a single line for a group with all of the values of Grade for that group displayed as a concatenated string in a single cell...

on27 Jul 2013
Wiki Page: Adding Links in SSRS Reports

Ed Price - MSFT

The Request Is it possible to have a field which contains a link to the build results? The Solution Yes. Links can be done in 2 ways (that I know of) in SSRS. The most common is to set the Action property of a control (textbox, image, etc.). If you right-click the control and open its...

on6 Jul 2013
Wiki Page: Setting Subreport Visibility From User Input

Tim Pacl

The Request: I have a main report with several sub reports. Can I allow the user to select which subreport will be rendered in the main report? The Solution : Yes. You can even allow the user to select multiple subreports to display with a multiselect parameter. Create a new parameter (ShowReport...

on5 Jun 2013
Wiki Page: Preset Date Parameters

Tim Pacl

The Request: I have built two reports, one with a Start Date and an End Date, and another with preset ranges (Last 7 Days, Last 30 Days). I am trying to see if there is a way to have a single combined report with maybe the following three fields: 1. Date Options - Last 7 Days, Last 30 Days, Custom...

on5 Jun 2013
Wiki Page: SQL Server Reporting Services Architecture

Carsten Siemens

SQL Server Reporting Services (SSRS) SSRS is a reporting tool from the Microsoft Business Intelligence group. It is a complete tool for all enterprise reporting requirements. It was initially released with SQL Server 2000 as a separate, installable product, and it was integrated with SQL Server...

on26 May 2013
Wiki Page: SSRS Development Effort Estimation Methodologies

Aalam Rangi

Table of Contents Overview Books Articles / Blog Posts Other Links This is a stub for the effort estimation methodologies useful for a SSRS development project. Overview Estimation methodologies for SSRS in particular or Business Intelligence in general can vary based on the size and complexity...

on14 Apr 2013
Wiki Page: SSRS Design Patterns

Aalam Rangi

Table of Contents Books Articles / Blog Posts Report Build Patterns Other Articles Case Studies This is a stub page for SQL Server Reporting Services (SSRS) design patterns. Having a collection of design patterns in one wiki will cut down on estimation, development and maintenance of SSRS projects...

on14 Apr 2013
Wiki Page: Error 31288 - SQL Server Reporting could not be configured for Forefront TMG

Yagmoth555

Table of Contents Scenario Cause Resolution Scenario Consider a scenario where the administrator changed the service account for MSSQL$ISARS from the local system account to a local user account. After the change, all recurring report jobs generated an error in the event log as follows: ...

on9 Apr 2013
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: SSRS

Ed Price - MSFT

Note: This page is currently a stub article. Add information as you can.

on24 Jan 2012