Create a RDLC report

Report Definition Language Client-side is the extension of the report file. The RDLC files does not require the SQL Server Reporting Services to process the reports.

This section describes step by step procedure to create an RDLC report in Standalone Report Designer. First, launch the Bold Reports RDLC Designer application shortcut from your desktop/start menu.

RDLC Report designer icon

The Bold Reports® RDLC Designer will launch with a new blank report.

Report designer initial view

Create data

  1. Click the Data icon in the configuration panel to open a Data configuration panel. Create new reporting application project
  2. Click on the NEW DATA button in DATA panel. Create new reporting application project
  3. Now, the Data Fields dialog will be opened like below. Create new reporting application project
  4. Edit the name of the Data in the Name field, if required.
  5. To create fields for the dataset, click on the ADD button. Create new reporting application project
  6. Provide the Field Name in the first dropdown list.
  7. In the second dropdown list, choose the datatype for the respective field. Create new reporting application project
  8. Similarly, you can create multiple fields for the dataset. Create new reporting application project
  9. Click on the OK button. Now, the dataset will be listed under the DATA pane like below. Create new reporting application project

Assign data

  1. Drag and drop a chart report item to the design area. Create new reporting application project
  2. Switch to the DATA tab in the properties panel. Create new reporting application project
  3. Select and drag the numeric column (measure element) or the numeric expression column from the Measure section and drop it in the Y Values section.
  4. Select and drag the dimension element from the Dimensions section to measure against any of the selected numeric column(s) in Y Value(s) section, and drop into the Column(s) section. Create new reporting application project
  5. Now, the final design will look like below. Create new reporting application project

Preview report

  1. Click on the Preview button in the toolbar. Now, the following dialog will be displayed. Create new reporting application project

  2. To bind data to the widgets, provide valid JSON array collection as shown in following sample code.

    [{
"ProdCat": "Accessories", "SubCat": "Helmets", "OrderYear": "2002", "OrderQtr": "Q1", "Sales": 4945.6925
},
{
"ProdCat": "Components", "SubCat": "Road Frames", "OrderYear": "2002", "OrderQtr": "Q3", "Sales": 957715.1942
},
{
"ProdCat": "Components", "SubCat": "Forks", "OrderYear": "2002", "OrderQtr": "Q4", "Sales": 23543.1060
},
{
"ProdCat": "Bikes", "SubCat": "Road Bikes", "OrderYear": "2002", "OrderQtr": "Q1", "Sales": 3171787.6112
},
{
"ProdCat": "Accessories", "SubCat": "Helmets", "OrderYear": "2002", "OrderQtr": "Q3", "Sales": 33853.1033
},
{
"ProdCat": "Components", "SubCat": "Wheels", "OrderYear": "2002", "OrderQtr": "Q4", "Sales": 163921.8870
},
{
    "ProdCat": "Bikes", "SubCat": "Road Bikes", "OrderYear": "2003", "OrderQtr": "Q2", "Sales": 4119658.6506
},
{
    "ProdCat": "Clothing", "SubCat": "Socks", "OrderYear": "2003", "OrderQtr": "Q3", "Sales": 6968.6884
},
{
    "ProdCat": "Bikes", "SubCat": "Road Bikes", "OrderYear": "2003", "OrderQtr": "Q4", "Sales": 3734891.6389
},
{
    "ProdCat": "Components", "SubCat": "Mountain Frames", "OrderYear": "2002", "OrderQtr": "Q3", "Sales": 608352.8754
}]

    Create new reporting application project

  3. Now, the report preview will be displayed like below. Create new reporting application project

Download the above report design from the link.