---
id: video/6dEZQlmBlyI
type: video
title: Use Data from a Report inside your Spreadsheet with Business Central  (Advanced Spreadsheets)
summary: Embedding report data in a spreadsheet with the Advanced Spreadsheets and reporting app for Business Central. Shows a report region (report 111 customer top 10), a donut chart built from it, live recalculation and filtering. Query regions are also mentioned.
tier: community
language: en
tags:
  - advanced spreadsheets
  - report regions
  - query regions
  - live data
  - filtering
  - charting
  - data visualization
system: reporting
review:
  state: reviewed
  by: opus
  at: "2026-10-07T23:18:05.984Z"
  flags: []
generated:
  at: "2026-10-07T23:18:06.027Z"
  pipeline: 0.2.0
  prompts:
    extract-video: 1
    summarize-video: 2
  input_hash: d4569f7e6a8d5f90df1a300209e78192b3e2c92c089118ad37194ebd03bc69f2
evidence:
  - kind: video
    url: https://www.youtube.com/watch?v=6dEZQlmBlyI&t=0s
    title: Use Data from a Report inside your Spreadsheet with Business Central  (Advanced Spreadsheets)
    date: "2026-09-21T19:14:15.000Z"
    commit: null
    t: 0
    quote: How to use data from a report inside your spreadsheet using the advanced spreadsheet and reporting app for Business Central.
  - kind: video
    url: https://www.youtube.com/watch?v=6dEZQlmBlyI&t=29s
    title: Use Data from a Report inside your Spreadsheet with Business Central  (Advanced Spreadsheets)
    date: "2026-09-21T19:14:15.000Z"
    commit: null
    t: 29
    quote: if you have a query inside your system that calculates something, you can get the data from a query inside your spreadsheet also.
  - kind: video
    url: https://www.youtube.com/watch?v=6dEZQlmBlyI&t=126s
    title: Use Data from a Report inside your Spreadsheet with Business Central  (Advanced Spreadsheets)
    date: "2026-09-21T19:14:15.000Z"
    commit: null
    t: 126
    quote: Every time you open the spreadsheet, the report is calculated. If you hit the the thingy, then the report is recalculated.
  - kind: video
    url: https://www.youtube.com/watch?v=6dEZQlmBlyI&t=141s
    title: Use Data from a Report inside your Spreadsheet with Business Central  (Advanced Spreadsheets)
    date: "2026-09-21T19:14:15.000Z"
    commit: null
    t: 141
    quote: you can still reference cells in filters.
  - kind: video
    url: https://www.youtube.com/watch?v=6dEZQlmBlyI&t=151s
    title: Use Data from a Report inside your Spreadsheet with Business Central  (Advanced Spreadsheets)
    date: "2026-09-21T19:14:15.000Z"
    commit: null
    t: 151
    quote: a live report inside your spreadsheet.
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
video_id: 6dEZQlmBlyI
channel: yt-hougaard
source_name: Erik Hougaard
url: https://www.youtube.com/watch?v=6dEZQlmBlyI
published_at: "2026-09-21T19:14:15.000Z"
duration_s: 173
captions: derived
audience:
  - functional consultant
  - developer
  - administrator
chapters:
  - t: 0
    title: Introduction and Overview
  - t: 18
    title: Creating a Report Region in Spreadsheet
  - t: 41
    title: Selecting and Displaying Report Data
  - t: 74
    title: Creating a Chart from Report Data
  - t: 126
    title: Live Report Features and Filtering
  - t: 163
    title: Conclusion and Next Steps
features:
  - name: Report Region in Advanced Spreadsheets
    status: unclear
    t: 18
    verified: false
    status_source: video
  - name: Query Region in Advanced Spreadsheets
    status: unclear
    t: 29
    verified: false
    status_source: video
  - name: Chart Creation from Report Data
    status: unclear
    t: 74
    verified: false
    status_source: video
  - name: Live Report Calculation and Refresh
    status: unclear
    t: 126
    verified: false
    status_source: video
  - name: Report Filtering in Spreadsheets
    status: unclear
    t: 126
    verified: false
    status_source: video
objects_mentioned:
  - report 111 customer top 10
quotes:
  - t: 0
    text: How to use data from a report inside your spreadsheet using the advanced spreadsheet and reporting app for Business Central.
    check: exact
  - t: 29
    text: if you have a query inside your system that calculates something, you can get the data from a query inside your spreadsheet also.
    check: exact
  - t: 126
    text: Every time you open the spreadsheet, the report is calculated. If you hit the the thingy, then the report is recalculated.
    check: exact
  - t: 141
    text: you can still reference cells in filters.
    check: exact
  - t: 151
    text: a live report inside your spreadsheet.
    check: exact
---

# Use Data from a Report inside your Spreadsheet with Business Central  (Advanced Spreadsheets)

> Embedding report data in a spreadsheet with the Advanced Spreadsheets and reporting app for Business Central. Shows a report region (report 111 customer top 10), a donut chart built from it, live recalculation and filtering. Query regions are also mentioned.

[Watch on YouTube](https://www.youtube.com/watch?v=6dEZQlmBlyI) · Erik Hougaard · 2026-09-21 · 2:53 · tier community · reviewed (checked by Opus)

## Overview

Erik Hougaard shows how to add a report region to a spreadsheet in the Advanced Spreadsheets and reporting app for Business Central. In the region you choose the report, set a maximum number of rows and decide whether to include headers. The demo uses the customer top 10 report (report 111).

He then builds a donut chart of top customers from the report data, with customer names as categories. The report is recalculated each time the spreadsheet is opened, and a button recalculates it on demand. Filters work like normal report filters and can reference spreadsheet cells. Query regions work in a similar way. The app is free to use in a Cloud Sandbox.

## Key points

- A report region embeds report data in the spreadsheet. You pick the report, a maximum number of rows, and whether to include headers.
- The demo uses report 111 (customer top 10) as the data source.
- A donut chart of top customers was built from the report data, with categories set to customer names.
- The report is recalculated every time the spreadsheet is opened, and a button recalculates it manually.
- Filters on an embedded report work like normal report filters, and the video says they can reference cells in the spreadsheet. This was mentioned but not fully demonstrated.
- Query regions let you pull data from a query that calculates something into the spreadsheet.
- The app is free to use in a Cloud Sandbox, so you can try it there.

## Chapters

- [0:00](https://www.youtube.com/watch?v=6dEZQlmBlyI&t=0s) Introduction and Overview
- [0:18](https://www.youtube.com/watch?v=6dEZQlmBlyI&t=18s) Creating a Report Region in Spreadsheet
- [0:41](https://www.youtube.com/watch?v=6dEZQlmBlyI&t=41s) Selecting and Displaying Report Data
- [1:14](https://www.youtube.com/watch?v=6dEZQlmBlyI&t=74s) Creating a Chart from Report Data
- [2:06](https://www.youtube.com/watch?v=6dEZQlmBlyI&t=126s) Live Report Features and Filtering
- [2:43](https://www.youtube.com/watch?v=6dEZQlmBlyI&t=163s) Conclusion and Next Steps

## Features

| Feature | Status | At |
|---|---|---|
| Report Region in Advanced Spreadsheets | status not stated, demoed | [0:18](https://www.youtube.com/watch?v=6dEZQlmBlyI&t=18s) |
| Query Region in Advanced Spreadsheets | status not stated | [0:29](https://www.youtube.com/watch?v=6dEZQlmBlyI&t=29s) |
| Chart Creation from Report Data | status not stated, demoed | [1:14](https://www.youtube.com/watch?v=6dEZQlmBlyI&t=74s) |
| Live Report Calculation and Refresh | status not stated, demoed | [2:06](https://www.youtube.com/watch?v=6dEZQlmBlyI&t=126s) |
| Report Filtering in Spreadsheets | status not stated | [2:06](https://www.youtube.com/watch?v=6dEZQlmBlyI&t=126s) |

## AL objects mentioned

As heard in the captions. A name that matches one object page by exact type and name links to it; the others stay as named.

- report "111 customer top 10" at [0:51](https://www.youtube.com/watch?v=6dEZQlmBlyI&t=51s)

Not found in BC28-30: report "111 customer top 10".

## Quotes

- [0:00](https://www.youtube.com/watch?v=6dEZQlmBlyI&t=0s) "How to use data from a report inside your spreadsheet using the advanced spreadsheet and reporting app for Business Central."
- [0:29](https://www.youtube.com/watch?v=6dEZQlmBlyI&t=29s) "if you have a query inside your system that calculates something, you can get the data from a query inside your spreadsheet also."
- [2:06](https://www.youtube.com/watch?v=6dEZQlmBlyI&t=126s) "Every time you open the spreadsheet, the report is calculated. If you hit the the thingy, then the report is recalculated."
- [2:21](https://www.youtube.com/watch?v=6dEZQlmBlyI&t=141s) "you can still reference cells in filters."
- [2:31](https://www.youtube.com/watch?v=6dEZQlmBlyI&t=151s) "a live report inside your spreadsheet."

Presenters (as heard): Eric.