Wednesday, 20 May 2009

Bug in SSRS 2008

I will start my blog with a bug I faced in SSRS 2008. It is to do with the InScope function, which was heavily used by developers in SSRS 2005. It is stated in lots of forums and books online that InScope is not required any more in SSRS 2008. I wrote my expression in the Omit expression box, but still faced the issue.

I was facing two problems -

1. Correct value not being passed to the jump-to-report
2. Disappearance of an item on collapsing another item

I had posted my problem on the MSDN forum, but didn't receive any reply.

After lot of searching on the web, I found this link, which states the list of bugs fixed in SQL Server 2008 SP1 - http://support.microsoft.com/kb/968369. Following link talks about my second problem in SSRS 2008 - http://support.microsoft.com/kb/961271.

I had Windows server 2003 R2 Enterprise Edition SP2 and Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (X64).

After going through the knowledge base article, I decided to install SQL Server 2008 SP1 on the server. Tested the reports again and voila, it worked.

I know it is a small post, but I just thought that it might be one of the very common issues developers might be facing and my experience would save their valuable time.

1 comment:

  1. Groovy, thanks you very very much... you've save me life... honestly, thanks god...

    ReplyDelete