Creating your own report templates when using Microsoft SQL Server Reporting Service

  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 reports that are developed and deployed all across the organization. How far have we gone…

3

Report Headers and Footers with Microsoft SQL Server Reporting Services

  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? Here you go, look at the below post on how to…

1

Accessing the ReportExecutionService.Render method when reporting service (2008 / R2) is in Forms based authentication (Using ReportingService.LogonUser method)

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 this code is, this is different from the conventional windows…

2

Reports showing stale data when using reporting services 2005

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 issues that I faced. 1.      There was a report with a multi-valued parameter. When…

0

Subscriptions do not get fired / executed from Reporting service

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 the Report server windows service has not done its job. Report server windows service…

2

Delete operation from a Reporting Service 2005 report manager fails with InternalCatalogException and throws watson mini dump

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.log) w3wp!library!12!07/13/2010-08:56:28:: a ASSERT: Assertion failed!   Call stack: Microsoft.ReportingServices.Library.DeleteItemAction.PerformActionNow()   Microsoft.ReportingServices.Library.DeleteItemAction.PerformActionInBatch(CallParameters parameters)   Microsoft.ReportingServices.Library.RSService.ExecuteBatch(Guid batchId)   Microsoft.ReportingServices.WebServer.ReportingService2005Impl.ExecuteBatch()   Microsoft.ReportingServices.WebServer.ReportingService2005.ExecuteBatch()   System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)   System.RuntimeMethodHandle.InvokeMethodFast(Object target,…

0

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

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 in report server and then run it from report builder, the report…

0

White Paper on Managing Kerberos Authentication Issues in a Reporting Services Environment

I’m pleased to announce the release of the white paper Manage Kerberos Authentication Issues in a Reporting Services Environment. The paper is now available for download at  http://msdn.microsoft.com/en-us/library/ff679930.aspx Special thanks to Bhejpal and Vijay for their exceptional work on investing their time and research to create this wonderful white paper. This paper will help  our…

0

Announcing the Report Builder portal page

I’m thrilled to announce that the new Report Builder portal went live yesterday afternoon. This portal page is a child page to the BI Resource Center on TechNet (technet.microsoft.com/bi). The Report Builder portal is the resource center for customers and partners who author reports in Report Builder. The goal of the portal is to gather…

0