Sql Server Custom Code Issue

I created a report in SQL Server 2005 using SQL Server 2005. I added a custom code to the report as:

function getpiececount_parent(byval qb_prodcode as string,byval s_date as string,byval e_date as string)

dim conn as new System.Data.SqlClient.SqlConnection

conn.ConnectionString= "Data Source=xxxx;Initial Catalog=xxxx;User Id=xxxx;Password=xxxxx "

conn.open()

dim sql as string

sql="select query using parameters"

dim cmd as new System.Data.SqlClient.SqlCommand

cmd.connection=conn

cmd.commandtext=sql

cmd.Parameters.AddWithValue("@stDate",s_date)

cmd.Parameters.AddWithValue("@edDate",e_date)

cmd.Parameters.AddWithValue("@qbprodcode",qb_prodcode)



dim retval =cmd.ExecuteScalar()

if retval is system.dbnull.value then

retval=0

end if



cmd.dispose()

conn.close()

return retval

end function



For the above function I added reference to the System.Data . The report works as desired when I execute in the VS 2005 IDE but when I deploy the report on the reporting server and execute it from there the function doesn€™t execute and returns me #Error.

Can any one provide some insight into it to as to how i can resolve this issue.