---
title: "ExecuteReport"
slug: "executereport"
updated: 2022-05-24T22:26:13Z
published: 2022-05-24T22:26:13Z
canonical: "docs.datajet.app/executereport"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.datajet.app/llms.txt
> Use this file to discover all available pages before exploring further.

# ExecuteReport

Standard Form

```json
{
  "method": "ExecuteReport",
  "filename": "%OUTPUT%SurveyDashboard.xlsx",
  "report": "Survey Dashboard",
  "byReference": true
}
```

Remove filename and **array of models** returned. "models" [ {"model":{}},{"model":{}} ,{"model":{}} ]

Add a **dataSet** to apply a filter or form an AND with existing filters for all member reports that support **dataSet** as an outer filter

```json
{
  "method": "ExecuteReport",
  "report": "Survey Dashboard",
  "byReference": true,
  "dataSet": {
  }
}
```

## 4.3.7.1

Added **"append": false(true)** and **"sheet" : string**

if exporting by reference, successive calls can be appended to the same workbook, and the worksheets can be named..

Added **"stack": false(true)** - successive components of a dashboard are stacked vertically

```json
[
  {
    "method": "ExecuteReport",
    "filename": "%OUTPUT%report1.xlsx",
    "sheet": "Attributes",
    "report": "Customer Attribute Index Dashboard",
    "byReference": true
  },
  {
    "method": "ExecuteReport",
    "filename": "%OUTPUT%report1.xlsx",
    "sheet": "Stats",
    "report": "Crosstab Stats Panel Dashboard",
    "byReference": true,
    "append": true
  }
]
```

## Iterators

Iterators can be applied when the report is being exported to a workbook.

An iterator contains either a **table** or a list of **fields.**

The referenced or inline report will be executed for every field in the list (or for the whole table)

Each result will be added to a new sheet in the workbook referenced in **filename**.

If using the table form, remove fields from the iteration by adding them to the **ignore** list.

Note: the fields and ignore list entries must be **full qualified fields names**.

```json
{
  "project": "MyProject",
  "method": "ExecuteReport",
  "filename": "%OUTPUT%OccupationbyStatus.xlsx",
  "report": "Occupation by Status",
  "byReference": true,
  "iterator": {
    "field": "cust.status",
    "table": "cust",
    "ignore": [
      "cust.occupation"
    ]
  }
}
```