ASP.NET Core Reports
Home
Product Line Sales
Company Sales
Mail Merge
Sales Report
Territory Sales
Conditional Row Formatting
Barcode
Customer Support Analysis
Tickets Sales Analysis
Website Visitor Analysis
Patient Experience Analysis
Personal Expense Analysis
Northwind Products and Suppliers Report
Sales Order Detail
Invoice
Product Catalog
Sales By Year
Grouping Aggregate
Product Details
Load Large Data
Consolidated Balance Sheet
Paystub
Dynamic Chart Series
Data Bar
Spark Line
Dynamic Columns
External Parameter Report
Parameter Customization
Sub Report
PowerPoint Report
Transcript Report
CMR Report
New
Infographics Report
New
Report Writer

Sales By Year

This demos allows you to view the sales by year RDLC that exist on the local file system with JSON array and custom business object data collection in ASP.NET Core Bold Report Viewer.

Report Processing...
using System; using System.Collections.Generic; using System.Linq; using System.Threading.Tasks; using Microsoft.AspNetCore.Mvc; namespace ReportsCoreSamples.Controllers.ReportViewer { [Route("report-viewer/sales-by-year")] public class SalesByYearController : PreviewController { [HttpGet("")] public IActionResult Index() { this.updateMetaData(); return View(); } } }
@inject Globals globals; @section control { <bold-report-viewer id="reportviewer" report-service-url="@Globals.SERVICE_URL" report-path="sales-by-year.rdlc" report-loaded="onReportLoaded" processing-mode="Local" toolbar-rendering="onToolbarRendering" tool-bar-item-click="onToolBarItemClick" export-item-click="onExportItemClick" /> <script> function onReportLoaded(args) { let reportNameWithoutExt = args.model.reportPath.split(".")[0]; let reportObj = $('#reportviewer').data("boldReportViewer"); reportObj.model.dataSources = rdlcData[reportNameWithoutExt]; } </script> }

The Sales By Year RDLC report represents the sales of North America countries in each year using Tablix and Chart report items.

  • The Row grouping feature is used to group the sales by year and the Column grouping feature is used to group Region and Country. More information about Grouping Panel can be found in this documentation section.
  • Aggregate functions are used to calculate the total sales in each countries.
  • Sorting is applied to row groups to sort the sales year.

More information about RDLC report can be found in this documentation section.