Sql Server Reporting Services Custom Assemblies

Optional parameters in custom DLLs

Page 1 of 1

0 Replies - 953 Views - Last Post: 10 September 2008 - 01:01 PM Rate Topic: -----

#1 jbrammeier  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 08-September 08

Sql Server Reporting Services Custom Assemblies

Posted 10 September 2008 - 01:01 PM

I'm not having an issue now - already solved it. I'm just posting here so someone else doesn't have to tear their hair out trying to figure out what the hell happened.

We have a custom DLL installed with SQL Reporting Services and functions called from reports. We recently added two optional parameters (VB) to one of the functions and the function stopped working from inside the reports. This was hard to track down since you don't get any error messages. Nothing in the event logs or the report services logs. Generally, these problems are related to security, so you start trying everything you can think of related to security.

It turns out, all we had to do was republish the reports. Apparently, when you publish the reports to the server, it looks at the custom assemblies and stores some info about the parameters. Who knew?

Is This A Good Question/Topic? 0
  • +

Page 1 of 1