Create an RDLC report

To create an RDLC report in the Bold Reports® Standalone Report Designer, launch the Bold Reports RDLC Designer shortcut from your desktop or Start menu, define the data fields, add a report item, and preview the report with JSON data.

RDLC (Report Definition Language Client-side) is the file extension of client-side reports. RDLC files do not need SQL Server Reporting Services to process the reports.

RDLC Report designer icon

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

Report designer initial view

How do I add data fields to an RDLC report?

An RDLC report has no data connection, so in the Standalone Report Designer you define the dataset fields yourself in the Data Fields dialog.

  1. Click the Data icon in the configuration panel to open a Data configuration panel.

Data icon in the configuration panel 2. Click on the NEW DATA button in DATA panel. New Data button in the Data panel 3. The Data Fields dialog opens. Data Fields dialog 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. Add button in the Data Fields dialog 6. Provide the Field Name in the first dropdown list. 7. In the second dropdown list, choose the datatype for the respective field. Field name and data type for a new field 8. Similarly, you can create multiple fields for the dataset. Multiple fields in the Data Fields dialog 9. Click on the OK button. The dataset is listed in the DATA pane. Dataset listed in the Data panel

How do I assign data to a chart in an RDLC report?

Drag a chart to the design area, open the DATA tab in the properties panel, and drag measure and dimension fields into the chart sections.

  1. Drag and drop a chart report item to the design area.

Chart report item dropped on the design area 2. Switch to the DATA tab in the properties panel. Data tab in the properties panel 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. Fields assigned to the chart 5. The finished chart design: Final chart design

How do I preview an RDLC report with data?

Click Preview and paste a JSON array whose properties match the dataset fields. The Standalone Report Designer renders the report with that data.

  1. Click on the Preview button in the toolbar. Now, the following dialog will be displayed.

Preview dialog for the RDLC report 2. To bind data to the report items, provide a valid JSON array, as shown in the following sample code.

```js
[{
"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
}]
```

JSON data bound to the report 3. The report preview opens. RDLC report preview

Download the sample RDLC report design from GitHub.