Hi, Thank for this article. It was very helpful for understanding adding assemblies to reporting services.
However, I have run into a problem. Everything worked like charm, in a report, I changed background-color of to the value I got from the the assembly created..etc until I tried to connect to a database and get the value from there. And the reporting services just displays #Error
The function that's connect to database is working fine. The reason is b/c I created Windows App that calls this function actually receives value from DB by calling this function.
The problem happens only when I call this from Reporting Services report.
I'm thinking it's some kind of security issue?
I hard-coded connection string to db in the function. basically, I used the exact same code as you posted in this article. I just changed values of connection string.
I appreciate any help or any response.