Using custom assemblies in SSRS

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

Using custom assemblies in SSRS

Author

Topic

bushfoot
Yak Posting Veteran

53 Posts

Posted - 2009-03-09 : 13:41:33

I have a c# assembly that I reference and use in my reports. I have followed all of the instructions on-line

1 - copied the file to the reportserver\bin folder of reporting services server

2 - added a code group to rssrvpolicy.config for the custom assembly to have full trust.

3 - added to my methods

SqlClientPermission operm = new SqlClientPermission(PermissionState.Unrestricted);

operm.Assert();

Still when I run the report in reporting services I get #Error. I do not see anything in the ReportingServices\logfiles to tell me why it doesn't work.

Any ideas? The purpose of the assembly is to pull resources for such things as Column headers, report names, translated report row data.

On my dev machine, with a BI:Report Server project I can copy my dll to the visual studio folder and when I run the report on the preview tab the column headers are translated. That is not the case on my reporting services server.

Any guidance would be greatly appreciated!

bushfoot
Yak Posting Veteran

53 Posts

Posted - 2009-03-09 : 13:52:15

Found my own answer:

Had to add
[assembly:AllowPartiallyTrustedCallers]
to my assembly

Phew!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources