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