Bold Reports for ASP.NET Core
Sales By Year
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.