Developing Matt

My Technical Journal

Calling Reports via URL

with 2 comments

I found this nice website that shows some tricks when calling a report from a report services engine.  Here is the summary:

To call a report directly you can  use http://SERVERNAME/ReportServer/?%DIRECTORYNAME%REPORTNAME&rs:Command=Render

This will prompt you with a parameter.  To pass the parameter and hide the question for the user tac on
&PARAMETER=PARAMETERVALUE&rc:Parameters=false

Hide the toolbar?  Add:
&rc:Toolbar=false

Set it to automatically open to excel or acrobat?
&rs:Format=Excel
or
&rs:Format=PDF

NOTE THE ADDITION TO THIS DISCUSSION LOCATED HERE

Advertisements

Written by matt

November 20, 2007 at 4:19 pm

Posted in Report Services

2 Responses

Subscribe to comments with RSS.

  1. What is the syntax when the ParameterValue has a space? For example: TestPlan Name. I am wondering if SharePoint even allows it. So far, I can’t get it to work when there is a space in the parametervalue. Any help is appreciated.

    Carlos Lizardi

    July 2, 2013 at 8:08 am

  2. It’s me again. My mistake. The question is the syntax when the Parameter has spaces. For example: &TestPlan Name=valuexyz

    Carlos Lizardi

    July 2, 2013 at 8:12 am


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: