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 Print...

  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...

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...

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...

Consider a report which contains an expression in the following format =(R eportItems!textbox1.Value+ReportItems!textbox2.Value) , exporting the report might fail with the following excpetion stack: w3wp!webserver!3!04/24/2010-15:41:27:: e ERROR: Reporting...

Continueing with my earlier post on the RDLC and Drill Through reports, in this article we'll be checking the second method of passing parameters through filtering of report items. The steps till completing the design of the reports are still going...

Recently I was looking for a sample that will help me with the concept of Passing parameters to DrillThrough reports in RDLC. I didn’t get one. So I thought of giving a try on the same and it came up pretty well. The tricky part with the RDLC is, even...

Lot of time we worked on Expression based connection strings. http://msdn.microsoft.com/en-us/library/ms156450.aspx The question that always arises is, does this work in Sharepoint integration mode as well. Well YES!!! It does work on Sharepoint...

It’s always been a challenge to setup Kerberos in environments where there would be multiple tiers involved for an application. As the number of tiers increase, there is an increase in the number of hops that would take place. It becomes even more difficult...

When you leave the report open in report manager idle for some time and accessing it fails with the following error message: (Any operation that causes a Postback event can kickout this error) w3wp!ui!6!11/19/2009-02:58:25:: e ERROR: The page has expired...

Have you ever noted down the difference when you open a CSV file in Excel which is exported from REPORTING SERVICE 2005 and REPORTING SERVICE 2008? The one which is exported from REPORTING SERVICE 2005 shows all the values for each row in a single...

I was working on an interesting case where the reporting service was moved back to Windows authentication from Forms based authentication (FBA). There were lot of subscriptions which were created using a forms based user account. Now when the reporting...

Recently I was looking for a sample that will help me with the concept of Passing parameters to sub reports in RDLC. I didn’t get one. So I thought of exploring more on to this and started off the journey. The tricky part with the RDLC is, even though...

1. How Duplicate SPN's in IIS can come in to picture? An SPN is a service principal name and usually uniquely identified in a domain with it's service name. for eg: If we have a machine name " test " in the domain " contoso.com " and we have...