Replacing custom assembly that is called by SSRS

• Keith Hobbs

  Newbie

  Points: 3

  More actions

  March 20, 2009 at 5:26 am

  #384171

  Very interesting article that I am trying to apply, given me lots of ideas that will save loads of time in the long run.

  I've created a C# dll that has a static method for calling a stored procedure in sql. This works on my local XP development box, but when I try deploying to a dev server the report renders but just with default settings, seems to completely ignore the assembly. I've tried adding tracing to a text file, event log but nothing appears anywhere. I do get logs created on my local machine, and if I call the dll from a test harness console app that appears to work, so I suspect my permissions are not correct somewhere or other.

  SSRS and IIS logs shed no light on the matter either.

  I have found one tip suggesting that if the dll is recompiled the SSRS service needs to be stopped and re-started to force a reload of the custom assembly.

  If anyone has any thoughts if I'm missing something obvious I would greatly appreciate it.

  Thank you

  Keith Hobbs

  Senior Software Engineer

  Good Energy Ltd

  Chippenham

  UK