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

Article
8/6/2021

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)

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

Clicking the drillthrough link in a 2008 Multi valued parameter report after exporting to MHTML / Word formats which contains drillthrough action (Go to report) fails

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, https://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...