SQL Server Performance Forum – Threads Archive

linking to a report from a web page

I want to create a link to my report on a website and pass the parameters for the report through the url. Do I use a URL similar to the following: http://localhost/Reports/Pages/Repo…R&StartWeek=5&StartYear=2004&SRID=SR10502.016 where the item path is the name of the report, or do I link to the report directly. Using the url above doesn’t seem to pass the paramters in. Am I missing something?

Levin,<br /><br />try to use this format for non parameter SQL Report.<br /><br /><a target="_blank" href=http://<serverName>/reportserver?/&lt<img src=’/community/emoticons/emotion-4.gif’ alt=’;p’ />ath>/Employee>http://<serverName>/reportserver?/&lt<img src=’/community/emoticons/emotion-4.gif’ alt=’;p’ />ath>/Employee</a><br /><br />eg.<a target="_blank" href=http://TestServer/reportserver?/Test/Employee>http://TestServer/reportserver?/Test/Employee</a><br />Where Employee is Report name<br /><br />For Parameterised report. use the following code.<br /><br /><HTML><br /><BODY><br /><FORM id="frmRender" action="http://TestServer/reportserver?/Test/Employee1" method="post"><br /> <INPUT type="hidden" name="rs:Command" value="Render"><br /> <INPUT type="hidden" name="rc:LinkTarget" value="main"><br /> <INPUT type="hidden" name="rs:Format" value="HTML4.0"><br /> <INPUT type="hidden" name="rc<img src=’/community/emoticons/emotion-4.gif’ alt=’

‘ />arameters" value="False"><br /> Employee UserId : <INPUT type="text" name="userid" value="Test"><br /> <INPUT type="submit" value="View Report"><br /></FORM><br /></BODY><br /></HTML><br /><br /><br /><br />Thanks,<br />Abhishek

]]>