Blog

CodeStock 2008 06/23/2008
Feedburner 06/11/2008
A Post About How I Haven't Posted 06/11/2008
I Almost Died On Sunday 05/28/2008
What's SharePoint Good For? 03/26/2008
Linking Membership to other tables 03/17/2008
Questions about Document Management with SharePoint 03/10/2008
Fixed! 02/27/2008
The Worst Cubicle Ever 02/22/2008
The Music Game: C 02/17/2008
Interesting situations 02/16/2008
The Music Game: B 02/10/2008
Your computer asplode 02/04/2008
The Music Game: A 02/04/2008
Blog meme 02/01/2008
Who's the biggest loser? 02/01/2008
The Survey and The $2 Bill 02/01/2008
It's a load bearing bottle 01/31/2008
The Phishers Aren't Trying Anymore 01/30/2008
Your skill in Confidence has increased by 1. 01/27/2008
The rewrite bug may be catching 01/22/2008
OMGWTFPHOTOS! 01/10/2008
Soy Latte Is People 01/04/2008
Rails is a Ghetto? 01/03/2008
2007, according to my blog 01/01/2008

Recent Updates

Programming: Windows SharePoint Services 3.0 Notes 06/30/2008
Programming: Windows Development Toolbox 06/13/2008
Etc.: About this Site 06/04/2008
Gaming: Wii Friend Codes 05/22/2008
Programming: SQL Reporting Services Notes 05/13/2008
Programming: SQL Server Notes 05/09/2008
Programming: .NET Notes 04/24/2008
Programming: Random Notes 04/04/2008
Programming: Networking Notes 04/04/2008
Gaming: DDR Tips 01/27/2008
Programming: SqlFixture 10/17/2007
Programming: WebSessions Log File Analyzer 10/17/2007
Etc.: Wallpaper 10/08/2007
Programming: IIS Notes 06/14/2007
Programming: ASP.NET Notes 06/14/2007
Programming: X360MediaServe Patch 05/19/2007
Etc.: Links 04/30/2007
Gaming: WoW: Reagent Tips 09/27/2006

Twitter Updates

View my Twitter profile

Content

SQL Reporting Services Notes

To use a custom assembly in Reporting Services, add the DLL to the following locations:

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

C:\Program Files\Microsoft SQL Server\80\Tools\Report Designer

```
C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin
```
(Actually, this is MSSQL.3 on my local installation, but it may be different for you.)

A convenient way of doing this is adding the following post-build event command line to your custom assembly project:

copy "$(TargetPath)" "C:\Program Files\Microsoft SQL Server\80\Tools\Report Designer"

copy "$(TargetPath)" "C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin"

copy "$(TargetPath)" "C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies"

Of course, if you're currently previewing a report using said assembly in Visual Studio, the last copy command will fail.

Post a Comment

To post a comment to this page, login below: