Error in SSRS Custom Code in Report server | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Error in SSRS Custom Code in Report server

hi all, I have written a custom code in a report which accesses the database whenever a parameter is passed to it. the code deletes the particular row from database according to the parameter passed. the report and code work fine till they are in report designer in VS 2005. but once deployed in report server if a parameter is passed then it throws an error. it doesnot give any description of error but simply give "#error". the probable problem in my understanding may be due to the fact that the report cannot acess the custom code in report server. Can any body help me on this Thanks… Regards G.Shankar
Have you checked the permission on the database server for the user who generates this custom code? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
]]>