Last post Mar 31, 2016 03:56 PM by rsford31
Mar 29, 2016 09:38 PM|rsford31|LINK
I've developed a report in Visual Studio 2012. I have a custom assembly that decrypts an encrypted field. I added the assembly to C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\bin.
In Report > Report Properties > References I navigated to the above location to add the assembly. I then added the class name (SolutionName.Encryption.EncryptionService) and the instance name (m_encryptionService)
I've added a calculated field to the report (=Code.m_encryptionService.Decrypt(Fields!EncryptedNumber.Value, Fields!EncryptionKey.Value)). When I go to the Preview tab I get the message:
An error occurred during local report processing. The definition of the report '/Report2' is invalid. Error loading code module 'Module name here'. Details: Could not load file or assembly 'assembly name here' or one of its dependencies. The system cannot
find the file specified.
Any ideas to why this is happening?
Mar 30, 2016 09:44 AM|Weibo Zhang|LINK
As I searched, you could first have a look at below links and follow them step by step to add your custom assembly to SSRS. As they show, you should also copy the dll to “c:\windows\assemblies” and create Strong Name Key for the assembly.
Mar 31, 2016 03:56 PM|rsford31|LINK
The first link worked. Thanks!