Excel
Video

Creating Datasets in Microsoft Report Builder

Lesson 7 Chapter 3

This video is part of the video course:
FREE Professional & Paginated Excel Reports without Power BI

To be able to create Paginated Excel Reports and use the data from our Data source (from our Excel database, Excel workbook) we need to create at least 1 Dataset.
Datasets are just like tables, query's or views in our databases.
In this video, we will create a simple SQL query to get the data from our data source.

The SQL query will be the most simple one. Something like:
SELECT * FROM table

This query tells the database engine that we want all the fields from the table.

Pen