Calling RS from ASP without losing Subscription capability

[Lenning, Jack]

I'm trying to create an asp.net application that can call Reporting Services
(RS2005) reports directly from a custom ASPX page. The report accepts
multiple parameters from the calling page. I'm able to get this to work by
displaying the called report in a reportviewer. Since the report is called
from a custom UI I have the report parameters hidden on the report.
Unfortunately this method appears to eliminate the ability for the user to
set a subscription for the report. The "New Subscription" link is not
available from the reportviewer toolbar. (Or the toolbar is missing
altogether)

Here's how the working URL appears:
http://servername/ReportServer/Pages/ReportViewer.aspx?%2fReportFolder%2fReportName&Parameter1=ParameterValue1&Parameter2=ParameterValue2

My thinking is that the subscription link being unavailable is due to the
fact that I'm not displaying the report in the "Report Manager", so I tried
to call the Report Manager by accessing it's URL directly.

http://servername/reports/pages/Report.aspx?ItemPath=%2fReportFolder%2fReportName&Parameter1=ParameterValue1&Parameter2=ParameterValue2

This method renders the report but does not apply the parameters. If I
have the parameters set as hidden on the report I get an error message
stating that the "The Parameter1 parameter is missing a value". If the
parameters are not set to hidden the report appears with the parameter
fields empty - waiting for their entry. (Not using the values I passed in
the URL) The "New Subscription" link appears as desired though.

My question is: How do I get the Subscription feature to work with the
ReportViewer method that I have working, and if that is not possible how can
I get an ASP application to display an RS report that accepts parameters in
the Report Manager, without the error message or the report parameter
prompts appearing? (instead of rendering the report using the parameter
values provided in the URL)

Thanks in advance,
Jack

[Bruce L-C [MVP]]

You did the URL incorrectly. There are two websites. Reports is the portal
(Report Manager) that ships with Reporting Services. ReportServer is
Reporting Services. You have to use ReportServer to pass parameters (See URL
Integration in Books Online). The tabs for subscription is Report Manager
(I.e. the portal) which you cannot pass parameters to.

If you don't want to use Report Manager but you want to use Subscriptions
then you need to provide your own UI and then use Web Services to generate
subscriptions.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

"Lenning, Jack" <jack.l...@courts.state.mn.us> wrote in message
news:#KPueVUY...@TK2MSFTNGP06.phx.gbl...

[Lenning, Jack]

Not the news I was hoping for but thanks for your prompt reply!
Jack

"Bruce L-C [MVP]" <bruce_l...@hotmail.com> wrote in message
news:O5KCl8XY...@TK2MSFTNGP02.phx.gbl...