Create an RDLC report using business object data source

To create an RDLC report for the Bold Reports^® JavaScript Report Viewer, build a business object class in Visual Studio, then add an RDLC report with the Report Wizard and configure its data source and table.

Prerequisites

• Microsoft Visual Studio 2017 or higher
• Microsoft RDLC Report Designer

If you use a Microsoft Visual Studio version lower than 2017, update SSDT with the Business Intelligence templates. Refer to Download SQL Server Data Tools.

How do I create the business object class?

To create the business object class for an RDLC report in the Bold Reports^® JavaScript Report Viewer, add a class with the report fields to a class library project in Visual Studio.

1. Open Visual Studio from the File menu and select New Project.
2. Create project with class library type from the project type list.

3. Create the class with the necessary properties. Use the following code as a reference.

```csharp
public class ProductSales
{
    public string ProdCat { get; set; }

    public string SubCat { get; set; }

    public string OrderYear { get; set; }

    public string OrderQtr { get; set; }

    public double Sales { get; set; }
}
```

4. Clean and build the application.

How do I add an RDLC report in Visual Studio?

To add an RDLC report in Visual Studio, use the Report Wizard item, which starts report creation with dataset selection.

1. Right-click the project and click Add > New Item.
2. Search Report with new item and select Report Wizard to start the report creation with dataset selection.
3. Click Add.

Data source and table configuration wizard

1. Choose object type from the Data Source Configuration wizard and click Next.

2. Expand the tree view and select ProductSales, and then click Finish.

3. In the DataSet Properties wizard, specify the dataset name as SalesData.

4. Drag the fields into Values, Row, and Column groups, and then click Next.

5. Choose the table layout and click Next.
6. Select table style and click Finish.

Visual Studio now displays the RDLC report design, as in the following image:

To render the RDLC report in the Bold Reports^® JavaScript Report Viewer, refer to the RDLC report section.