linking to a report from a web page | SQL Server Performance Forums

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://&lt;serverName&gt;/reportserver?/&lt<img src=’/community/emoticons/emotion-4.gif’ alt=’;p’ />ath&gt;/Employee>http://&lt;serverName&gt;/reportserver?/&lt<img src=’/community/emoticons/emotion-4.gif’ alt=’;p’ />ath&gt;/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 />&lt;HTML&gt;<br />&lt;BODY&gt;<br />&lt;FORM id="frmRender" action="http://TestServer/reportserver?/Test/Employee1" method="post"&gt;<br /> &lt;INPUT type="hidden" name="rs:Command" value="Render"&gt;<br /> &lt;INPUT type="hidden" name="rc:LinkTarget" value="main"&gt;<br /> &lt;INPUT type="hidden" name="rs:Format" value="HTML4.0"&gt;<br /> &lt;INPUT type="hidden" name="rc<img src=’/community/emoticons/emotion-4.gif’ alt=’:p‘ />arameters" value="False"&gt;<br /> Employee UserId : &lt;INPUT type="text" name="userid" value="Test"&gt;<br /> &lt;INPUT type="submit" value="View Report"&gt;<br />&lt;/FORM&gt;<br />&lt;/BODY&gt;<br />&lt;/HTML&gt;<br /><br /><br /><br />Thanks,<br />Abhishek