SQL Server Performance

Error in SSRS Custom Code in Report server

Discussion in 'SQL Server 2005 Reporting Services' started by girija45701, Jan 11, 2007.

  1. girija45701 New Member

    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
  2. satya Moderator

    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.

Share This Page