sql server reporting services: Hello.

I need to use RS in my web application and I intend to use the URL
integration to call the reports. I know more or less how to do it, but my
only trouble is to use it in search pages.

As the search result is a variable set, I need a way to pass the search
parameters to the report. I tried with a report that calls my search stored
procedure, but it puts the parameters in the report. Is it possible to pass
the parameters so the user just sees the result report?

--
Regards,

Diego F.

You can use Get parameters IE

<FORM id="frmRender"
action="http://server/reportserver?/SampleReports/Territory Sales Drilldown"
method="post" target="_self">
<INPUT type="hidden" name="rs:Command" value="Render">
<INPUT type="hidden" name="rc:LinkTarget" value="main">
<INPUT type="hidden" name="rs:Format" value="HTML4.0">
<INPUT type="submit" value="Button">
</FORM>


This is docd in SQL Books on line - search for "URL ACCESS through a Form
Post"
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC

I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.


[quoted text, click to view]