The data binding support allows you view RDLC reports from the local file system with JSON array and custom business object data collection. Follow these steps to render an RDLC report with JSON array and custom business object data collection.
Add the RDLC report
product-list.rdlcfrom the Bold Reports® installation location to your application’sApp_Datafolder. For more information, refer to Samples and demos.
To bind the data source at client side, follow these steps;
reportPath property.processingMode property to ProcessingMode.Local.dataSources property as shown in following code.<bold-reportviewer id = "reportViewer_Control"
[reportServiceUrl] = "serviceUrl"
[dataSources] = "reportData"
[reportPath] = "reportPath"
[processingMode] = "processingMode"
style = "width: 100%;height: 950px">
</bold-reportviewer>import { Component } from '@angular/core';
@Component({
selector: 'ej-app',
templateUrl: 'src/reportviewer/reportviewer.component.html',
styleUrls: ['src/reportviewer/reportviewer.component.css']
})
export class ReportViewerComponent {
public serviceUrl: string;
public reportPath: string;
public reportData: any;
public processingMode: string;
constructor() {
this.serviceUrl = 'https://demos.boldreports.com/services/api/ReportViewer';
this.reportPath = 'product-list.rdlc';
this.processingMode = "Local";
this.reportData = [{
value: [
{
ProductName: 'Baked Chicken and Cheese', OrderId: '323B60', Price: 55, Category: 'Non-Veg', Ingredients: 'grilled chicken, corn and olives.', ProductImage: ' '
},
{
ProductName: 'Chicken Delite', OrderId: '323B61', Price: 100, Category: 'Non-Veg', Ingredients: 'cheese, chicken chunks, onions & pineapple chunks.', ProductImage: ' '
},
{
ProductName: 'Chicken Tikka', OrderId: '323B62', Price: 64, Category: 'Non-Veg', Ingredients: 'onions, grilled chicken, chicken salami & tomatoes.', ProductImage: ' '
}
],
name: 'list'
}];
}
}The following steps help you configure the Web API to render the RDLC report with business object data collection.
Create a class and methods that return business object data collection. Use the following code in your application’s Web API Service.
public class ProductList
{
public string ProductName { get; set; }
public string OrderId { get; set; }
public double Price { get; set; }
public string Category { get; set; }
public string Ingredients { get; set; }
public string ProductImage { get; set; }
public static IList GetData()
{
List<ProductList> datas = new List<ProductList>();
ProductList data = null;
data = new ProductList()
{
ProductName = "Baked Chicken and Cheese",
OrderId = "323B60",
Price = 55,
Category = "Non-Veg",
Ingredients = "grilled chicken, corn and olives.",
ProductImage = ""
};
datas.Add(data);
data = new ProductList()
{
ProductName = "Chicken Delite",
OrderId = "323B61",
Price = 100,
Category = "Non-Veg",
Ingredients = "cheese, chicken chunks, onions & pineapple chunks.",
ProductImage = ""
};
datas.Add(data);
data = new ProductList()
{
ProductName = "Chicken Tikka",
OrderId = "323B62",
Price = 64,
Category = "Non-Veg",
Ingredients = "onions, grilled chicken, chicken salami & tomatoes.",
ProductImage = ""
};
datas.Add(data);
return datas;
}
}Set the value of the ProcessingMode property to ProcessingMode.Local and ReportPath in the RDLC report location.
Bind the business object data values collection by adding a new item to the DataSources in the Web API controller as shown in the following code snippet.
[NonAction]
public void OnInitReportOptions(ReportViewerOptions reportOption)
{
reportOption.ReportModel.ReportPath = System.Web.Hosting.HostingEnvironment.MapPath(@"~/App_Data/Product List.rdlc");
reportOption.ReportModel.DataSources.Add(new BoldReports.Web.ReportDataSource { Name = "list", Value = ProductList.GetData() });
}Here the
Nameis case sensitive and it should be same as in the data source name in the report definition. TheValueaccepts IList, DataSet, and DataTable inputs.
To load report as a stream, create a report stream using the FileStream class and assign the report stream to the Stream property.
[NonAction]
public void OnInitReportOptions(ReportViewerOptions reportOption)
{
string filePath = System.Web.Hosting.HostingEnvironment.MapPath(@"~/App_Data/Product List.rdlc"); ;
// Opens the report from application's App_Data folder using FileStream
FileStream reportStream = new FileStream(filePath, FileMode.Open, FileAccess.Read);
reportOption.ReportModel.Stream = reportStream;
reportOption.ReportModel.DataSources.Add(new BoldReports.Web.ReportDataSource { Name = "list", Value = ProductList.GetData() });
}In the previous code, the
Product List.rdlcreport is loaded from theApp_Datafolder location.
You can get the user-selected parameter details when users clicks the ViewReport button in the parameter block. The viewReportClick event allows you handle the ViewReport button click at the client side as shown in the following code.
<bold-reportviewer id="reportViewer_Control"
[reportServiceUrl] = "serviceUrl"
[processingMode] = "Remote"
[reportServerUrl] = "serverUrl"
[reportPath] = "reportPath"
[locale]= Remote
(viewReportClick) = "viewReportClick($event)">
</bold-reportviewer>import { Component, ViewChild } from '@angular/core';
import { BoldReportsAngularModule } from '@boldreports/angular-reporting-components/src/core';
@Component({
selector: 'ej-app',
templateUrl: './app.component.html',
styleUrls: ['./app.component.css']
})
export class AppComponent {
public serviceUrl: string;
public reportPath: string;
public serverUrl: string;
constructor() {
this.serviceUrl = 'https://demos.boldreports.com/services/api/ReportApi';
this.reportPath = 'GroupingAgg.rdl';
}
viewReportClick(event) {
var reportParams = [];
reportParams.push({ name: 'ReportParameter1', labels: ['SO50756'], values: ['SO50756'] });
event.model.parameters = reportParams;
}
}The model property in the event argument has the details of current processing report model.