Search results
PDF

Create a RDLC report using business object data source

This section describes step by step procedure to create an RDLC report using Visual Studio Reporting project type.

Prerequisites

If you are using Microsoft Visual Studio lower to 2017 version then you should update SSDT with the Business Intelligence templates. Refer to Download SQL Server Data Tools.

Create business object class

  1. Open Visual Studio from the File menu and select New Project.

  2. Create project with class library type from the project type list. Add a new class library project

  3. Create the class with necessary properties. You can find the reference below,

    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.

Add an RDLC report

  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. Add a new rdlc using report wizard template

Data source and table configuration wizard

  1. Choose object type from the Data Source Configuration wizard and click Next. Select data source type in configuration wizard

  2. Expand the tree view and select ProductSales, and then click Finish. Choose data object class in the application namespace

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

  4. Drag the fields into Values, Row, and Column groups, and then click Next. Arrange table row, column and value groups

  5. Choose the table layout and click Next.

  6. Select table style and click Finish. Choose table toggle, repeat header and total options

Now, the RDLC report is displayed in the Visual Studio as follows. Visual Studio design output of the sales report

To render the RDLC using Report Viewer, refer to the RDLC Report section.