You can run reports directly at the command prompt if you know the ID of the report. This can be useful if you need to run a specific report for testing or you know the ID of a report that you run often.

In addition, you can filter the data in the report by adding a filter string to the command. The filter string has the following format:

  CopyCode imageCopy Code

To specify the table, you use the DataItemVarName of the data item. For more information, see DataItemVarName Property.

To specify the field, use the field name. If the field name contains special characters, then you must enclose it in quotation marks by using the URI escape sequence %22.

The colon operator separates the two parts of the filter string.

To specify the value, you can either use a single value or a comparison operator and a value. The following are the valid comparison operators:

The wildcard character * is permitted in the value.

You can specify multiple filter strings by concatenating them. For example, the following command filters on cities that begin with M and names that begin with A.

  CopyCode imageCopy Code

To use a shortcut to run a report

  1. In Windows, on the taskbar, click Start and then click Run.

  2. In the Run dialog box, enter the following command: dynamicsnav:////runreport?report=<ReportID>[&filter=<table>.<field>:<value>]

  3. Replace <ReportID> with the report ID that you want to run. If you want to filter the data, then replace <table>, <field>, and <value> with the appropriate values.

  4. Click OK to run the report.

See Also