I have been trying to get a custom assembly to run with SQL Reporting Services 2005, but everything I have tried up to this point produces the same result.
Every column which references the Custom Assembly comes back with the value #Error.
With the Preview tab, it runs fine, which leads me to believe its a permissions issue. However, I added the following <CodeGroup> tag to my rssrvpolicy.config to fix the permissions problem.
<CodeGroup
class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Name="MyCustomAssemblyCodeGroup"
Description="A special code group for my custom assembly.">
<IMembershipCondition class="UrlMembershipCondition"
version="1"
Url="C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportServer\bin\ExecuteQuery.dll"
/>
</CodeGroup>
</CodeGroup>
</CodeGroup>
</PolicyLevel>
</policy>
</security>
</mscorlib>
</configuration>
My code group is placed in the spot several online tutorials said to place.
After any changes to this file, I restarted the SQL Server Reporting Services Service.
I'm pretty sure that the .dll file is in the correct directory because without the .dll in that location, the report deployment from Visual Studio 2005 would fail.
I've tried to run the report in Debuglocal mode by selecting DebugLocal from the build type drop down box in VS 2005 and pressing F5.(By build type drop down box, I'm referring to the one next to the green play button) This does not seem to pop up a test window like some tutorials would suggest. Instead it actaully deploys the report to the report server and opens up the Production Report Server in my browser window. I'm assuming I must have a step wrong for entering DebugLocal mode.
Finally, acording to the SQL Reporting Services Log, It does not appear to encounter any errors. Here is the log entry when I try to access the reports:
w3wp!library!9!05/18/2006-14:13:34:: i INFO: Call to CreateReport( 'SQLRSContactHistoryonDetails', '/Sales Department/Details Report', def)
w3wp!library!9!05/18/2006-14:13:34:: i INFO: Call to SetReportDefinition( '/Sales Department/Details Report/SQLRSContactHistoryonDetails', def )
w3wp!library!9!05/18/2006-14:13:36:: i INFO: Call to CreateReport( 'SQLRSContactHistoryonDetailsXLS', '/Sales Department/Details Report', def)
w3wp!library!9!05/18/2006-14:13:36:: i INFO: Call to SetReportDefinition( '/Sales Department/Details Report/SQLRSContactHistoryonDetailsXLS', def )
w3wp!library!9!05/18/2006-14:13:37:: i INFO: Call to CreateReport( 'SQLRSHomeOfficeActivity', '/Sales Department/Details Report', def)
w3wp!library!9!05/18/2006-14:13:37:: i INFO: Call to SetReportDefinition( '/Sales Department/Details Report/SQLRSHomeOfficeActivity', def )
With that all out of the way, is there something else I need to do, or I am doing something wrong that is causing the #error to remain around Also, is there some other way to debug this problem

Debugging Errors with Custom Assemblies.