Report and document selection scripts

This table shows specific display or data options for your report:

Control Properties For Use With Value Description Example
CMD RPT

Other document types

URL

CMD or &OpenReport Use CMD=HELP to display the parameters help document from a browser.

From a URL, you can specify OpenReport to open the report. You need to indicate the report to open by using the ReportID or ReportName properties.

The following is a full URL example: CMD=OpenReport

The following is a exporting and scheduling example (for use with RPT, only):

  • ReportID=<Report_ID>&OpenReport
  • ReportName=<Report_ID>&Open
  • ReportDocName=<Report_ID>&Open
  • ReportReport=<Report_ID>&OpenReport
DocID or ReportID RPT

Other document types

<ID_number> Opens the report, report instance, or document by ID. The following is a full URL example: DocID=23 ReportID=045

The following is a full URL example for exporting or scheduling (for use with RPT, only):

&DocID=1

Note: To find an ID number for a report or historical instance of a report, access the administrative system folder containing the documents. The path for this folder can be found in the Reporting Services system settings.
DocName, Report, or ReportName RPT

Other document types

<Name> Opens the document by its Reporting Services published name.
  • &ReportName=Balance Sheet
  • &Report=Balance Sheet
  • &DocName=Balance Sheet
Note: For all published documents the name is the friendly name inputted by the report publisher or owner. This name appears in the Name column on the My Reports list in Reporting Services
InstanceID RPT Latest

<Instance Number>

Opens the latest instance of the report or the instance of the report by instance number.
  • &InstanceID=Latest
  • &InstanceID=12
Instance Name <Instance Name> Opens the report by instance name.
Destination RPT Browser (default)

Disk

Indicates the location for the Report output.

Browser displays the report in the browser.

Disk creates a new instance.

&Destination=browser