The Curious Engineer

All blogs / Databases

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

learn.microsoft.com/en-us/archive/blogs/selvar

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

DatabasesC# / .NETMicrosoft blogsMSDN archive

’10’15’20’25
Posts
104 from 8 Nov 2007 to 22 Jul 2017
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/selvar/feed.xml

2017 7

  1. Rendering a large report in SharePoint mode fails with maximum message size quota exceeded error message
  2. URL access with rc:Toolbar command fails with rsRenderingExtensionNotFound
  3. Configuring Reporting Services 2016 with ARR
  4. Configuring the Pickup directory for Reporting Services
  5. Demystifying Last Run column in Report Manager Details View
  6. Reporting services support for Microsoft EDGE browser
  7. Intermittent E_ACCESSDENIED when opening SSRS related contents

2015 1

  1. IE 11 browser support for Reporting services versions prior to 2012

2014 7

  1. Report exported to PDF causes all the spaces in between the words to be compressed
  2. Using Report Viewer control in ASPX pages
  3. Performance improvement feature request for the Reporting Services in SharePoint mode
  4. #Error on RDLC report with built in report server fields running on and above .NET 4.0 with ASP.NET role manager enabled
  5. ReportViewer control with SSRS 2012 in SharePoint Integrated mode throws rsExecutionNotFound exception
  6. Report definition not specified error with RDLC report
  7. Visual Studio 2012 and 2013 crashes when you bind datasource to RDLC from Report Viewer web control

2013 9

  1. ReportViewer 2012 control not showing Print icon when viewed from IE 11 (Desktop mode)
  2. ReportServerTempDB growing large : One of the causes
  3. Displaying fixed number of rows in Report using expression based page break
  4. Using Reporting Service web part with SharePoint custom master pages
  5. SharePoint web part page hosting ReportViewer web part fails with Sys.WebForms.PageRequestManagerTimeoutException: The server request timed out
  6. SSRS SharePoint List data provider querying a SharePoint List in Claims enabled site with Windows and Forms Based Authentication selected
  7. Reporting service ENCRYPTION KEY automated backup REPORT utility
  8. Working with RDLC(2012) and passing parameter to sub report in Report Viewer 2012 control
  9. ReportExecutionService.Render method in SharePoint integrated mode

2012 7

  1. ReportViewer control fails with Sys.WebForms.PageRequestManagerServerErrorException: Failed to load viewstate.
  2. Reporting service keeps committing physical memory in NUMA architecture even when Reporting services is not under heavy load
  3. Reporting services unexpectedly loads .NET Framework 4.0 by default and fails with HTTP 500 while browsing Report Server and Report manager URL
  4. ReportViewer 2010 control fails with Sys.WebForms.PageRequestManagerTimeoutException: The server request timed out
  5. ReportViewer 2010 Winforms control takes too much of time to render a local mode report (RDLC) when we launch the application using ClickOnce.
  6. Page break or Interactive height not honored and the report with toggling shows the entire contents in single page
  7. Modifying report variables in Reporting service 2008 R2

2011 4

  1. Report builder 3.0 stops responding after you run a query more than two times against a report model when Authentication mode for Reporting Service 2008 R2 is set for Basic or Custom authentication
  2. Browsing a report from Report manager / Report server always show page 0 of 0 in the tool bar
  3. Interactive sorting in Reporting service fails with rsReportNotReady exception
  4. Invoking the Print dialog for report viewer 2010 control using the JavaScript API

2010 14

  1. Creating your own report templates when using Microsoft SQL Server Reporting Service
  2. Report Headers and Footers with Microsoft SQL Server Reporting Services
  3. Accessing the ReportExecutionService.Render method when reporting service (2008 / R2) is in Forms based authentication (Using ReportingService.LogonUser method)
  4. Reports showing stale data when using reporting services 2005
  5. Subscriptions do not get fired / executed from Reporting service
  6. Delete operation from a Reporting Service 2005 report manager fails with InternalCatalogException and throws watson mini dump
  7. Report Builder 2.0 / 3.0 errors out with 'The operation has timed out' when previewing a report saved in Report Server takes more than 10 minutes
  8. Alternate pages will appear blank on Reports created in Reporting Service 2008 / R2 when exported to Image / PDF / Print
  9. White Paper on Managing Kerberos Authentication Issues in a Reporting Services Environment
  10. Announcing the Report Builder portal page
  11. Export to excel from SSRS 2005 report fails with System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
  12. Dynamically passing parameter to DrillThrough report in RDLC - Part 2
  13. Dynamically passing parameter to DrillThrough report in RDLC - Part 1
  14. Expression based connection strings in Sharepoint integration mode

2009 8

  1. Scenario based Kerberos setup with Reporting Service in Sharepoint integration mode.
  2. 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.
  3. Reports exported in CSV from Reporting Service 2008, when opened in EXCEL shows each comma seperated values in new column
  4. Cannot click Subscriptions tab after Moving to Windows Authentication from Forms based Authentication
  5. Working with RDLC and passing parameter to subreport in Report Viewer control
  6. Reporting Service Frequently Asked Questions (FAQ)
  7. ERROR: An attempt has been made to use a data extension 'SQL' that is not registered for this report server.
  8. 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

2008 7

  1. Editing RDL programatically using C#
  2. RepeatWith not working with Physical Paginations like Print, Image and PDF
  3. CanShrink does not work with RDLC when the textbox is within a data control like Table / Matrix
  4. System.Data.Odbc.OdbcDataReader.GetBytes() always returns 0 when you use with ExecuteReader(CommandBehavior.SequentialAccess)
  5. Getting System.OutOfMemoryException when using ReportViewer contol in Local mode
  6. 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
  7. ConnectionLifetime attribute in the SqlConnection connection string is not honored

2007 40

  1. ERROR: The number of requests for XXXServerXXXUser has exceeded the maximum number allowed for a single user
  2. Using ADO in VB and Access
  3. ADO Cursors
  4. ADO Model
  5. Reporting services - Verbose Logging
  6. Reporting Services - LOG Files
  7. SQL CLR INTEGRATION
  8. KERBEROS - Inside OUT
  9. OLEDB API Calls
  10. OLE DB Resource Pooling
  11. ADO Overview and Architecture
  12. MSDASQL - OLEDB Provider for ODBC drivers
  13. OLE DB Programming Overview and Architecture
  14. Troubleshooting and Monitoring Pooling issues
  15. ODBC Connection Pooling
  16. How to Enable ODBC Connection Pooling Performance Counters
  17. ODBC Tracing
  18. ODBC Programming Overview and Architecture
  19. MDAC Install Issues - Excellent Overview
  20. MDAC Rollback - Overview
  21. MDAC Versions Available - OS Compatibilities
  22. Microsoft JET Basics
  23. MDAC Setup - Common Failure Scenarios
  24. MDAC and SQL Server - MDAC Versions shipped
  25. MDAC-MS Access - Deprecated Jet Engine
  26. MDAC Setup - Installation Best Practices
  27. Available Release Manifests for MDAC Products
  28. MDAC on 64bit Operating System
  29. Tools to Troubleshoot 32 bit MDAC issues
  30. Reporting Service Execution Logging
  31. Reporting Services Performance Optimization
  32. Reporting Services 2005 Performance Counters
  33. Report Caching
  34. How to configure Reporting Services for Scale-out Deployment
  35. Reporting Services Server Components
  36. Report Request Handling
  37. Reporting Services architecture diagram
  38. SQL Vs Oracle ODBC Driver DLL Path
  39. .NET database connection ARCHITECTURE to SQL Server
  40. What is MDAC?