Reporting Services - Rendering report via Web Service on dicountasp

Hello. I'm new to SQL Reporting Services but not .NET.

Can't seem to find the right syntax to call the Reporting Services Web Service by either of the following:
1. Passing the report path and output format via a urlto a page that calls the Web Service OR
2. hard coding both the report path and report output format and calling the Web Service with those 2 values from within the .aspx page.

This knowledgebase article includes the code for #2 above http://kb.discountasp.net/article.aspx?id=10335
I think I'm sending thewrong path info and format string. The reports I'm using do exist and work fine via the html/url interface rendering.

If anyone has a sample of either method of calling the web service please send me a sample of your URL string (Option #1) OR the path and format strings you would use in option #2.

Please don't send any userid or password in a sample. I know how to authenticate with the web service (although that might be an issue here also -I hope not)

Any help greatly appreciated with this.
I will post whatever I get working in case it will be of help to someone else.

 

Bruce, Thanks for the follow up. I got this working - for example redering from code:

results = rs.Render("/myuserid/reports/reportname", "HTML4.0", _
Nothing, "<DeviceInfo><StreamRoot>/WebApplication1/</StreamRoot></DeviceInfo>", Nothing,credentials, Nothing, Nothing, Nothing, Nothing, Nothing, streamids)


Now I'm trying to get rid of the logon prompt by sending the username and password.
In the above example the credentials parameter in rs.Render is set to Nothing.

Do you have any info on how to configure the security or what params to pass to the render?
Thanks

 

Thanks Bruce. In an attempt to get rid of the Report server authentication I changed the settings for the web application with the rendering page to


<authentication mode="None" />


<authorization>


<allow users="*" />


and already had the Reporting Service Credentials valued.So I'm still getting a prompt to connect to rs.discountasp.net. Maybe not authenticating before making the call to the web service is the problem?


Thanks for your help.

 

http://www.wirelessathome.biz/webrenderingvb/foo.aspx

Thank you.

 

Bruce

OK, I will try to create a simpler report and get back to you.

Where in this string is the unknown content that you are suggesting might be causing the authentication problem? There is a plus sign prompt to expand the report - maybe that's the problem but I am curious about what content you are talking about in this output from the report server.
Thanks for your help.


https://rs.discountasp.net/ReportSe...ShowHideToggle=24&amp;rs:Snapshot:isnull=True