# One report per store or region | DRE

> Sets run the same report once per client, each with its own file and recipient.

[← All use cases](https://getdre.com/#use-cases)

# One report per store or region

Every client, region or store gets its own statement: same layout, their data, their file name, their email address. A Set is a named variant of a report, so the SQL and the layout are written once.

Recorded from a real run: one command, then the three emails it sent.

Recorded from a real run: one command, then the three emails it sent.

![The Mailpit test inbox with three statement emails, one per client](https://getdre.com/media/client_statement/inbox.webp)

The test inbox (Mailpit): one email per client, each with their own workbook. The addresses are fictional.

[↓ Download one client’s workbook (client A)](https://getdre.com/media/downloads/client_a-adhoc-20261001.xlsx)

reports/statements/client\_statement.yml

```yaml
  - {query: statement_header, tab_name: Statement}
  - {query: statement_lines, tab_name: Orders}
output:
  format: xlsx
  destination:
    - {profile: local, path: "out/statements/{{ var('client') }}-{{ run.schedule or 'adhoc' }}-{{ run.date.yyyymmdd }}.xlsx"}
    - profile: mail_local
      to: "{{ var('recipient') }}"
      subject: "[dre-demo] {{ var('client_label') }} statement ({{ var('period') }})"
      body: "Dear {{ var('client_label') }},\n\nYour statement for {{ period(var('period')).start.date }} to {{ period(var('period')).end.date }} is attached."
sets: [client_a, client_b, client_c]
default_set: client_a
```

sets.yml

```yaml
client_a: {vars: {client: client_a, client_label: "Client A", region_code: APAC, recipient: client-a@dre-demo.test}}
client_b: {vars: {client: client_b, client_label: "Client B", region_code: EMEA, recipient: client-b@dre-demo.test}}
client_c: {vars: {client: client_c, client_label: "Client C (pilot)", region_code: NAM, recipient: client-c@dre-demo.test}}
```

terminal

```bash
dre run client_statement --set all
```

### What to notice

-   Adding a client is one line in sets.yml.
-   Each Set can change variables, the source profile, the tabs or the whole output.
-   The Set’s variables feed the SQL, the file name and the email recipient.
-   Schedules name when each report runs; your orchestrator fires them.

### In the docs

-   [Templates and variables →](https://getdre.com/docs/templates/)