Open a report through a URL with parameters

Search: Find

Home

Book

Contents

Preview

Articles

Tools

Newsletters

Premium

Ask

About

Most Popular Articles

Using Secure Sockets Layer (SSL) for SQL Server 2000 Reporting Services
Creating an SSL Certificate to ensure your confidential reports remain confidential

SQL Reporting Services - Answers to your questions

Notify me of new comments

Author

Thread: Open a report through a URL with parameters

Douceman

Open a report through a URL with parameters
Posted: Tuesday, December 08, 2009 7:58 PM (GST)

Hi, I'm trying to open a report directly from a URL. The datasource is a MS cube and there's a prompt. I try the following URL with the exact syntax as if I was querying a database, but it doesn't work. The behavior is the same as if I don't supply a parameter. http://analytics/ReportServer/Pages/ReportViewer.aspx?%2fMSRS%2fopportunitycube&rs:Command=Render&STATIONStationName=FT-1 Can someone help?

Comments:

Author Thread:

William Vaughn

Open a report through a URL with parameters
Posted: Thursday, December 10, 2009 9:33 PM (GST)

What exception do you get? Can you navigate to the Virtual Directory ()? Did you install RS on the default SQL Server instance or on a named instance. If the latter is true, you'll need to specify the instance name in the URL as for SS 2008 I use "SS2K8" as the instance name thus:http://analytics/ReportServer_SS2K8/ gets me to the VD. So, once here, click on the desired report. If this fails then let's see the exception message.