Getting Started with Seal Report: Creating a Pivot Table with Custom Filters
This is the second post in the series. In this article, I assume that you’re already familiar with how to configure a data source in Seal Report and how to set up metadata model elements from a tab...

Source: DEV Community
This is the second post in the series. In this article, I assume that you’re already familiar with how to configure a data source in Seal Report and how to set up metadata model elements from a table loaded via the catalog. You can find the previous post here: Getting Started with Seal Report: Building Your First Data Table from SQL Server Vlad Ganușceac Vlad Ganușceac Vlad Ganușceac Follow Mar 21 Getting Started with Seal Report: Building Your First Data Table from SQL Server #sealreport #opensource #analytics #sqlserver 1 reaction Comments Add Comment 4 min read The previous report used only out-of-the-box features. In this tutorial, we will extend it by adding a pivot table and introducing custom filters. Adding a Pivot Table Since the current report visualizes data from the HumanResources.Employee and Person.Person tables of the AdventureWorks2025 database, we need to use a one-to-many relationship with one of these tables to provide data suitable for a pivot table. Let’s drag the