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:
Copy Code | |
---|---|
&filter=<table>.<field>:<value> |
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:
-
> (greater than)
-
>= (greater than or equal to)
-
< (less than)
-
<= (less than or equal to)
-
<> (not equal to)
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.
Copy Code | |
---|---|
DynamicsNAV:////runreport?report=104&filter=Customer.City:M*&filter=Customer.Name:A* |
To use a shortcut to run a report
-
In Windows, on the taskbar, click Start and then click Run.
-
In the Run dialog box, enter the following command: dynamicsnav:////runreport?report=<ReportID>[&filter=<table>.<field>:<value>]
-
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.
-
Click OK to run the report.