Let us create a report to represent sales data using tables and charts.

Create Report in Visual Studio Integrated Designer

1. Install ActiveReports.     

2. In Microsoft Visual Studio 2022 (version 17.0 or above), select ActiveReports 18 ASP.NET Core MVC Application template and click Next.
   
   For complete list of built-in templates, see the Project Templates.

3. Type a name for your project and click Create.
   

4. In the New Report wizard, choose the Report Type as RDLX and click Next.
   

Create Report in Standalone Designer

1. Run the ActiveReports Designer.
2. Go to File and click New to create a new report.
3. In the New Report wizard, choose the Report Type as RDLX and click Next.
   

Bind Report to Data

1. On the Choose Data Source Type screen of the wizard, select CSV and click Next.
2. On the Configure CSV Connection screen, specify the File Path by clicking the Browse button and navigating to the desired folder on your system. Let us bind data to the AcmeStore.csv file. See CSV topic for more information.
   
3. Click Next to proceed to the step of configuring CSV data fields.
   
4. Click Next to proceed to the final screen of the Report Wizard.
   
5. On the final screen of the Report Wizard, review the summary of the report and click Finish to successfully add the report with the CSV data source.

Design Report Layout

ReportSection1

1. In ReportSection1, which is open by default in the design area, drag-drop a Chart data region from the Toolbox to the design area.
2. Design a chart that shows the total sales in different cities. See Create Stacked Column Chart tutorial to visualize the data in a stacked column chart.
3. Click the ReportSection1 tab and from the Properties panel, set PaperOrientation to 'Landscape'.
   

ReportSection2

1. From the New tab that appears below the design area, add ReportSection2.
2. In this section of the report, drag-drop the Table data region.
3. Delete the third column of the table since we want to display payment methods and the order prices as the sales data. This data will be grouped by payment method, city, and region.
4. Select the Details row, right-click, and select Insert Group from the context menu. We will be adding three groups - payment method, city, and region.
5. In the Table - Groups dialog, add the groups and set the Name and Group on > Expression in the following sequence as follows:
   

   S.no.	Name	Expression
   1.	GroupByRegion	=[region]
   2.	GroupByCity	=[city]
   3.	GroupByPaymentMethod	=[payment_method]

      
6. Click OK to close the dialog.
7. Delete the Details row of the table.
8. Populate the data in the Table data region as follows:
   1. Merge the first table group and in the Value property of the merged cell, enter the expression ="Region: "Fields!region.Value
   2. Merge the second table group and in the Value property of the merged cell, enter the expression ="City: "&Fields!city.Value
   3. In the third table group, enter the following expression in the first and second cell, respectively:
      1.  =Fields!payment_method.Value
      2. =Sum(Fields!order_price.Value)
9. Click the ReportSection2 tab and from the Properties panel, set PaperOrientation to 'Portrait'.
      

ReportSection3

1. From the New tab that appears below the design area, add ReportSection3.
2. In this section, drag-drop a Chart data region to plot the average order price by payment method using a Bubble chart. See Create Bubble Chart tutorial to visualize the data in a bubble chart.
3. Click the ReportSection3 tab and from the Properties panel, set PaperOrientation to 'Landscape'.
   

ReportSection4

1. From the New tab that appears below the design area, add ReportSection4.
2. In this section, drag-drop a Table data region and drop the fields onto the table cells to display the average order price and payment method and the product item count.
3. Click the ReportSection4 tab and from the Properties panel, set PaperOrientation to 'Portrait'.
   

Preview Report

The final report is shown at the beginning of this page.