Have you ever run in to a scenario where you’ve Reporting service in SharePoint integrated mode. You’ve a web part page that hosts the Report Viewer web part that comes with the Reporting services Add-in. The report takes more than 90 seconds to complete...

Have you tried creating a report in BIDS / SSDT / Report Builder 3.0   using the Reporting Services(SSRS) SharePoint List extension against a SharePoint list in a Claims based SharePoint site? The Claims authentication has both Windows and Forms...

I’ve come across immeasurable number of circumstances where I meet customers with a non working Reporting Service production instance due Encryption key lost or corrupted. To add more to the agony we end up figuring out that there is no valid encryption...

This is an exact replica of the post: http://blogs.msdn.com/b/selvar/archive/2009/08/30/working-with-rdlc-and-passing-parameter-to-subreport-in-report-viewer-control.aspx But the difference is, it is customized for Report Viewer 2012 control as it...

Reporting service provides very convenient way of rendering your reports with the help of Web Service API's. You'll find a whole lot of documents out there in the web. But one thing we often have to search is, what should be the PATH of the report when...

Recently i was working on a very interesting scenario. Imagine you've have an ASP.NET web application that hosts ReportViewer web control. The ReportViewer control pulls a Reporting Services 2008 R2 report. The report contains background images in...

Have you worried about Reporting service constanly keeps consuming the physical memory even when the reporting service is not under stressful condition? This specifically happens when you have NUMA architecture enabled on the Server. So, if you've...

This week i was working on a challenging case where we've reporting service 2008 R2 installed and when we start the service from Reporting services configuration manager, it starts itself successfully. When you tried to browse either the report manager...

Think about a scenario where you have a report that takes more than 90 seconds to complete its operation and give the rendered report back to you. The report renders perfectly as expected when you view it from Report manager (For our convenience lets...

Have you ever wondered why your report processing prematurely terminated? Or While you execute a SSRS web service API call, suddenly you see it failing without any proper information? For today’s discussion, I’m taking an example where I upload a report...

When you have a report that contains multi level / recursive toggling, As a report developer have you ever wondered why my report just shows up in one single page? Have you ever been in a situation where you are forced to think why neither the interactive...

Have you ever wondered why launching an application that has Report viewer 2010 Winforms control through clickonce takes multiple times more time to render the report in Local mode? Try launching the same application directly by double clicking the EXE...

I've seen multiple times where we create a Read / Write Report variable ( Group variables are striclty Read only ) but not able to find a way to over write the value during the report execution phase. Here is a way to do it. Assume that you've created...

Recently few of our customers complained about the issue of Report builder 3.0 not responding upon certain operation. It was very tricly scenario and it took us much time to exactly figure out what could have caused the issue. This happens only...

Recently i came across another interesting issue where, When browsing report server URL and then viewing any report that spans multiple pages shows 0 of 0 pages in the tool bar. This also disables the page navigations. You'll see a very similar...

Recently i came across an interesting issue where the Interactive sorting in reports fail with the following exception, The selected report is not ready for viewing. The report is still being rendered or a report snapshot is not available. (rsReportNotReady...

Have you tried the new JavaScript libraries exposed by Report viewer 2010 control? Please go through Brian’s blog on JavaScript API and the MSDN documentation on the same. Ok, now lets see how we can leverage one of the methods to invoke the...

  When you’re creating a reporting service solution for your organization, the first thing you would decide before going any further with the report design is the finalization of a report template. A standard template does add professional look to...

  You would have seen page headers and page footers for reports (Can be enabled through the Report menu –>  Add Page Header / Add page footer in BIDS). Have you ever wondered how to have report headers and report footers for your reports...

Recently was working on an interesting sample which will help you to render a report using the web service API where reporting service is in Forms Based Authentication (FBA). This code was tested with SSRS 2008 and SSRS 2008 R2 (KJ). The reason for publishing...

Reporting services 2005 is an amazing reporting tool with a lot of dependency on IIS. Recently I came across an interesting scenario where the reports in the native mode and the SharePoint integration mode were showing stale data. There were couple of...

Recently i was working on a very interesting case where reporting service in sharepoint integration mode didn't fire any subscriptions. We looked at the Event table of reporting service and found there are huge amount of entries. This clearly shows that...

When ever you try deleting an object from reporting service 2005 report manager, it fails with the following error stack in the log file (<Installation Directory>:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles\ReportServer_TimeStamp...

Consider this scenario, Using Report Builder 2.0 or 3.0, you create a report which takes more than 10 minutes to render. When we run the report (Directly Preview without saving it in report server) it comes up fine. But after saving the report...

I was recently working on an intersting issue where you'll see blank pages on alternate pages when the report is exported to PDF / Image / Print. I was checking the usual formula of, Width of the report body + left margin + right margin < Report...