Creating Paginated Reports from scratch

Build Paginated Reports Using Power BI Report Builder

Language: english

Note: 0/5 (0 notes) 208 students New course

Instructor(s): Bluelime Learning Solutions

Last update: 2022-09-17

What you’ll learn

Create a report with Power BI Builder
Configure the report header
Create a data source
Create a dataset
Configure the report parameter
Add textboxes to report header
Add table to report
Format the report data region
Prepare report for printing

Requirements

Basic knowledge of Power BI advised but not mandatory
Basic knowledge of SQL advised but not mandatory

Description

Paginated Reports are special kind of reports that a user can fully customize. These reports are called paginated because a user can format them in page layout for printing purpose. Report designers can control the full page layout and every pixel of the page as they want, and that’s why these reports are also called pixel perfect. Designers only create one layout containing syntax and expressions to print and publish all the data present in a dataset. Paginated reports are beneficial for the companies to print invoice and sale records.

Power BI Report Builder is a tool for authoring paginated reports that you can publish to the Power BI service. Paginated reports are designed to be printed or shared. They’re formatted to fit well on a page, and they display all the data in a table, even if the table spans multiple pages. When you design a paginated report, you’re creating a report definition that specifies what data to retrieve, where to get it, and how to display it. When you run the report, the report processor takes the report definition you have specified, retrieves the data, and combines it with the report layout to generate the report. You preview your report in Report Builder. Then publish your report to the Power BI service.

You don’t need any license to download Power BI Report Builder from the Microsoft Download Center for free. You can publish and share paginated reports in your My Workspace or in other workspaces, as long as the workspace is in a Power BI Premium capacity and you have write access to the workspace.

Who this course is for

Beginner Data Analyst
Beginner Power BI Data Analyst
Beginner Data Scientist

Course content

SQL Server Setup
- Introduction
- What is SQL Server
- SQL Server Editions
- SQL Server Installation Requirements
- Download SQL Server
- SQL Server Installation
- SQL Server Configuration Manager
- Install SQL Server Management Studio – SSMS
- Connect SSMS to SQL Server
- Restore sample database
Creating Paginated Reports
- What are paginated reports
- Install Power BI Report Builder
- Create a blank report
- Configure the report header
- Create a data source and dataset
- Configure the report parameter
- Add textboxes to report header region
- Add a table to the report
- Format the table data region
- Finalize the report design