How can I display sql reporting service reports without login?

[eUKShane]

The simplest way is to wrong an asp page with following code:

[%

set objhttp = server.createobject(\\\"microsoft.xmlhttp\\\")

url = \"http://sqlreport339.mysite4now.com/ReportServer?/chris/sales order detail/&rs:Command=Render&rs:Format=HTML4.0&rc:Toolbar=Tr ue&rc:JavaScript=False&rc:LinkTarget=_top&rc:Area= Report\\\"

objhttp.open \\\"get\\\", url, false, \\\"login\\\", \\\"password\\\"

objhttp.send
response.write objhttp.responsetext

%]

You must know the report server url, your report path, and report server parameters. You can use the parameter shown in the sample. For detail of the parameters you can search msdn.

If the report you designed requires interaction between report and browswer or there\\\'s embeded item like images in your report, this does not work well and user will get password prompt.

Best Regards,
UKShane
http://www.eukhost.com