How to Debug Custom Assemblies in SQL Server Reporting Services (SSRS) 2005

The simplest way to step through an assembly in SSRS 2005 is to add the custom assembly solution to your current reporting project and specify which report you want to debug the assembly against.

Pre-requisite:
You must ensure that the DLL of your assembly is copied to reporting services private assembly location (see below) otherwise your report won’t recognize it.

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies

You need to do this at least once and anytime you update the assembly code. In the case of updates you need to close VS altogether before you can copy it to the directory. Reason being is because Reporting Services only loads assemblies once and keeps it in memory for improved performance.

a. To add an existing assembly project to your reporting project just go File -> Add -> Existing Project.

011

b. To specify the report you want to debug go Project -> Properties

018

That’s really all there is to it. You can step through your code by adding breakpoints to your custom source and hitting F5. The most common problem you’ll probably run into is you forget to update the DLL to reporting services private assembly location.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s