Calling my web service from the custom code is failing -- sql server reporting services

sql server reporting services : Calling my web service from the custom code is failing

yogeshprabhu NO[at]SPAM hotmail.com
11/16/2004 1:46:06 PM

This is what I'm trying to achieve. I want to call into my custom
assembly from the reports, and that assembly in turn calls a web
service. The reason I have to do that is because I think we can't
directly call a web service from the reports. To complicate the things
further I also have Forms Authentication enabled on Reporting
services.

Forms authentication enables me to use User!UserID which I pass on to
my custom assembly. The assembly in turn passes the parameter to web
service. To test the functionality I was trying to return simply
"Hello " + parameter value from the web service.

I have copied the custom assembly code to report manager's bin and
report server's bin directories. I have also added CodeGroup to
rssvrpolicy.config file to give a "FullTrust" permission on my custom
assembly.

The reports works as expected in Preview tab in VS.NET designer, but
when accessed from report manager or from the report server via URL,
the expression in text box shows #Error.

Please help to explain how to debug and fix the problem. Thanks much.

yogeshprabhu NO[at]SPAM hotmail.com
11/17/2004 1:01:05 AM

I have finally managed to get web service call working. I was able to
do this by asserting System.Net.WebPermission. Here's code snippet:

//Add following at the top of the class file
using System.Net;
using System.Security.Permissions;

//Add these lines just before instantiating web service proxy class
WebPermission webPerm = new
WebPermission(PermissionState.Unrestricted);
webPerm.Assert();

Remember to add exception handling code otherwise when functions in
custom code fails you will get "#Error" in the textbox in the report
without explaining what went wrong. If your methods return strings
then for debugging purposes you can return ex.ToString() which will at
least let you know what went wrong.

mikey
11/25/2004 8:41:01 AM

Hi Yogesh,

Help..
Tried all of the above and still getting the #error on my report - I can
call a different function in the dll (not using a web service) and that is
fine..
Do I need to set up any policies in the rssvrpolicy.config file ?

I have added the reference in my code Web.Assert code - so it looks like I
still have problems with the config files ..

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

home · blog · groups

Questions? Comments? Contact the dn