The one stop shop for FIXING your Reporting Service's Issues

Here you can find most of the details regarding the reporting service troubleshooting on different scenarios.

Expression based connection strings in Sharepoint integration mode

Lot of time we worked on Expression based connection strings....

Author: Selvar Date: 02/02/2010

Scenario based Kerberos setup with Reporting Service in Sharepoint integration mode.

It’s always been a challenge to setup Kerberos in environments where there would be multiple tiers...

Author: Selvar Date: 12/09/2009

Leaving a report idle in report manager and acessing it again throws, System.Exception: The page has expired. To re-open it, you must access the original page.

When you leave the report open in report manager idle for some time and accessing it fails with the...

Author: Selvar Date: 12/02/2009

Reports exported in CSV from Reporting Service 2008, when opened in EXCEL shows each comma seperated values in new column

Have you ever noted down the difference when you open a CSV file in Excel which is exported from...

Author: Selvar Date: 09/04/2009

Cannot click Subscriptions tab after Moving to Windows Authentication from Forms based Authentication

I was working on an interesting case where the reporting service was moved back to Windows...

Author: Selvar Date: 09/03/2009

Working with RDLC and passing parameter to subreport in Report Viewer control

Recently I was looking for a sample that will help me with the concept of Passing parameters to sub...

Author: Selvar Date: 08/30/2009

Reporting Service Frequently Asked Questions (FAQ)

  1. How Duplicate SPN's in IIS can come in to picture? An SPN is a service principal name and usually...

Author: Selvar Date: 04/30/2009

ERROR: An attempt has been made to use a data extension 'SQL' that is not registered for this report server.

PROBLEM: When you try to run a report (or) Generate a model from an existing Data Source (or) Open a...

Author: Selvar Date: 03/20/2009

PROBLEM: 1. Consider a report (rptParent) with a multi value query based parameter and it has links...

Author: Selvar Date: 03/16/2009

Editing RDL programatically using C#

Recently i was working on an issue. In Reporting Service 2005 you set FixedHeader property to a...

Author: Selvar Date: 11/05/2008

RepeatWith not working with Physical Paginations like Print, Image and PDF

PROBLEM: When we set the RepeatWith property of a TEXTBOX to the table / data region that holds the...

Author: Selvar Date: 10/09/2008

CanShrink does not work with RDLC when the textbox is within a data control like Table / Matrix

ISSUE: As per definition, http://msdn.microsoft.com/en-us/library/ms251779.aspx Growing and...

Author: Selvar Date: 10/09/2008

System.Data.Odbc.OdbcDataReader.GetBytes() always returns 0 when you use with ExecuteReader(CommandBehavior.SequentialAccess)

Consider a sample which reads an image from the SQL Server table (Adventure Works database), whose...

Author: Selvar Date: 07/18/2008

Getting System.OutOfMemoryException when using ReportViewer contol in Local mode

PROBLEM: ======== Consider you've a ASP.NET application that contains Report Viewer control (2005 /...

Author: Selvar Date: 07/18/2008

When you develop a report model project in SQL Server 2005 Business Intelligence Development Studio, the Isolation option in the Data Source Designer does not have any effect

Consider the following scenario in Microsoft SQL Server 2005 Reporting Services. You use SQL Server...

Author: Selvar Date: 05/01/2008

ConnectionLifetime attribute in the SqlConnection connection string is not honored

Created a sample code. == It has the ConnectionLifetime attribute in the connection String set to 10...

Author: Selvar Date: 05/01/2008

ERROR: The number of requests for XXXServerXXXUser has exceeded the maximum number allowed for a single user

When you browse the Report Manager, you're getting the above error message. To resolve this issue,...

Author: Selvar Date: 12/13/2007

Using ADO in VB and Access

ActiveX Data Objects (ADO) Overview ActiveX Data Objects (ADO) Design Philosophy ActiveX Data...

Author: Selvar Date: 11/11/2007

ADO Cursors

The CursorLocation and the Cursortype properties of the ADO Recordset object determine what we are...

Author: Selvar Date: 11/11/2007

ADO Model

Author: Selvar Date: 11/11/2007

Reporting services - Verbose Logging

Recently wrote a new tool to assist in enabling / disabling verbose logging which supports Reporting...

Author: Selvar Date: 11/10/2007

Reporting Services - LOG Files

RSSTP<xx>.LOG and RSMSI<xx>.LOG - During installation, the wizard logs all of its...

Author: Selvar Date: 11/10/2007

SQL CLR INTEGRATION

The common language runtime (CLR) integration feature is off by default in Microsoft SQL Server, and...

Author: Selvar Date: 11/10/2007

KERBEROS - Inside OUT

Kerberos Checklist General Kerberos scenario Client logs in to the KDC using the domain account. The...

Author: Selvar Date: 11/10/2007

OLEDB API Calls

What is OLE DB? OLE DB is a specification. It is not a set of components or files. It defines the...

Author: Selvar Date: 11/10/2007

OLE DB Resource Pooling

OLE DB resource pooling, also known as OLE DB session pooling, is handled by the OLE DB core...

Author: Selvar Date: 11/10/2007

ADO Overview and Architecture

ADO is the most popular and well-known of Microsoft’s Data Access API’s. ADO is, like...

Author: Selvar Date: 11/10/2007

MSDASQL - OLEDB Provider for ODBC drivers

As mentioned before, a provider is needed for any data source that is to be exposed through OLE DB....

Author: Selvar Date: 11/10/2007

OLE DB Programming Overview and Architecture

OLE DB is a COM based object model used for access to various relational data sources as well as...

Author: Selvar Date: 11/10/2007

Troubleshooting and Monitoring Pooling issues

Resources available - Performance Monitor (Perfmon) - Database-specific resources can be used SQL...

Author: Selvar Date: 11/10/2007

ODBC Connection Pooling

The operation of establishing a connection to a database can be expensive. In applications that...

Author: Selvar Date: 11/10/2007

How to Enable ODBC Connection Pooling Performance Counters

ODBC Connection Pooling enhances the performance of database connections. By default, the...

Author: Selvar Date: 11/10/2007

ODBC Tracing

Another tool frequently used for troubleshooting ODBC problems is ODBC Tracing. ODBC Tracing is a...

Author: Selvar Date: 11/10/2007

ODBC Programming Overview and Architecture

ODBC ODBC (Open Database Connectivity) is an older technology designed to allow developers to create...

Author: Selvar Date: 11/10/2007

MDAC Install Issues - Excellent Overview

1 Checking whether MDAC is installed correctly There are many problems that can be caused by MDAC...

Author: Selvar Date: 11/10/2007

MDAC Rollback - Overview

  • Very few scenarios require that a previous version of MDAC is used - Use as a last resort! Not...

Author: Selvar Date: 11/10/2007

MDAC Versions Available - OS Compatibilities

        Windows ME Windows NT 4.0 Windows 2000 Windows XP Windows 2003...

Author: Selvar Date: 11/10/2007

Microsoft JET Basics

Access and Jet Jet is the ubiquitous term for the access database engine. The Microsoft Jet OLE DB...

Author: Selvar Date: 11/10/2007

MDAC Setup - Common Failure Scenarios

  • User Not logged in as Admin. - Not enough disk space - Anti-Virus is running - Windows 9x missing...

Author: Selvar Date: 11/10/2007

MDAC and SQL Server - MDAC Versions shipped

SQL Server Version MDAC Shipped SQL Server 7.0 RTM MDAC 2.1 RTM SQL Server 7.0 SP 1 MDAC 2.1 SP 1...

Author: Selvar Date: 11/10/2007

MDAC-MS Access - Deprecated Jet Engine

  • Starting with MDAC 2.6 Jet is no longer shipped as a part of MDAC. - MDAC 2.5 SP2 had complete...

Author: Selvar Date: 11/10/2007

MDAC Setup - Installation Best Practices

  • Terminate applications that use MDAC: - Certificate Server - Internet Explorer - Internet...

Author: Selvar Date: 11/10/2007

Available Release Manifests for MDAC Products

SUMMARY This article lists the locations of the available release manifests for Microsoft Data...

Author: Selvar Date: 11/10/2007

MDAC on 64bit Operating System

• 64 bit MDAC debuted with MDAC 2.7 • MDAC builds are compiled to 32 bit and 64 bit...

Author: Selvar Date: 11/10/2007

Tools to Troubleshoot 32 bit MDAC issues

Component Checker Component checker is a tool which helps you to find the status of MDAC. If there...

Author: Selvar Date: 11/09/2007

Reporting Service Execution Logging

  • The Execution Log contains information of Report that executes across multiple servers in a...

Author: Selvar Date: 11/09/2007

Reporting Services Performance Optimization

Generic guidelines - All SQL performance best practices are applicable. - Optimize Report Data Set...

Author: Selvar Date: 11/09/2007

Reporting Services 2005 Performance Counters

There are two counters available for Reporting Services 2005 –-> MSRS 2005 Web Service...

Author: Selvar Date: 11/09/2007

Report Caching

Report Caching is used to improve performance There are 2 types of caching: Temporary Cached Report:...

Author: Selvar Date: 11/09/2007

<Previous Next>