Hi, I am using a resource file dll for localisation. I have placed the files in the following locations, c:\Program files\MicrosoftSQL Server\MSSQL3\Reporting services\Report Server\Bin c:\Program files\MicrosoftSQL Server\MSSQL3\Reporting services\Report Server c:\Program files\Microsoft Visual Studio 8\Common7\IDE\Public Assemblies c:\Program files\Microsoft Visual Studio 8\Common7\IDE\Private Assemblies and in the GAC of the server and still i get the error (#error). It works fine in the Report Designer, if i use the parameter Japan it gets the value from the dll file and it shows without any error but when i deploy the report and run in the report manager it throws me an error (#error) at the respective location. Please let me know what else i need to do?

Hi kcmania, The error is caused by Code Access Security setting in SQL Server Reporting Services(SSRS). We need to configure the code access security in the rssrvpolicy.config and rsmgrpolicy.config configuration files. Additionally, we just need to copy the assembly to: c:\Program files\MicrosoftSQL Server\MSSQL3\Reporting services\Report Server\Bin c:\Program files\MicrosoftSQL Server\MSSQL3\Reporting services\Report Manager\Bin c:\Program files\Microsoft Visual Studio 8\Common7\IDE\Private Assemblies For more information about Code Access Security in SSRS, please see: http://msdn.microsoft.com/en-us/library/ms154658.aspx If you have any more questions, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT

Thanks Jin, I really apreciate it. I have one more issue here to ask you, in my Local System, I have the Report Server folder at c:\Program files\MicrosoftSQL Server\MSSQL3\Reporting services\Report Server\Bin but at the Report server level, where i deploy my report, the Report Server Folder is at c:\Program files\MicrosoftSQL Server\MSSQL2\Reporting services\Report Server\Bin so i am placing the Assembly files in the MSSQL 2/Report Server/bin at the Server Level. Will this be of any problem when i reference the dll in the Report Properties Tab? So when i use the reference in the report Properties tab, should i point it to c:\Program files\Microsoft Visual Studio 8\Common7\IDE\Private Assemblies as reference which is common at both Local System and as well the Server Level, because i dont want the report to search for dll files in MSSQL3 where as they are actually available in the MSSQL2 in my Reporting server.

Thanks Jin, I really apreciate it. I have one more issue here to ask you, in my Local System, I have the Report Server folder at c:\Program files\MicrosoftSQL Server\MSSQL3\Reporting services\Report Server\Bin but at the Report server level, where i deploy my report, the Report Server Folder is at c:\Program files\MicrosoftSQL Server\MSSQL2\Reporting services\Report Server\Bin so i am placing the Assembly files in the MSSQL 2/Report Server/bin at the Server Level. Will this be of any problem when i reference the dll in the Report Properties Tab? So when i use the reference in the report Properties tab, should i point it to c:\Program files\Microsoft Visual Studio 8\Common7\IDE\Private Assemblies as reference which is common at both Local System and as well the Server Level, because i dont want the report to search for dll files in MSSQL3 where as they are actually available in the MSSQL2 in my Reporting server.

Hi Jin, I tried doing all the above what you have told me and still i get the same error (#error) I deployed in my Local host and i get the same error where as in the Preview mode it worked fine. I am using SqL Server 2005. Can you please help me here.

Hi kcmania, Could you please post the configuration files here? I will analysis them, and check if there is anything incorrect. Thanks, Jin ChenJin Chen - MSFT

Hi Jin, I did the changes and it worked in my local host server. but i did the same changes in Report server but still it dint work. I am not able to understnad what am i supposed to do more??