ActiveReports 16 .NET Edition
ActiveReports 16 User Guide / How To / Page Report/RDL Report How To / Report Controls / Create Custom Labels in a Chart
In This Topic
    Create Custom Labels in a Chart
    In This Topic

    With the Text encoding that supports any dataset field in chart labels and tooltips, you can create custom labels to use in a chart.

    This example uses the Column Chart with the FactSales dataset and displays Net Sales and Product Category data. The custom labels display the information on the net sales amount across each product category.

    Custom Labels

    Create a Report

    In the ActiveReports Designer, create a new RDL report.

    Bind Report to Data

    The Report Data Source dialog is invoked when a new report is created if you keep the default check on for the Launch Data Source Wizard option. You can also access this dialog by right-clicking the Data Sources node in the Report Explorer and then selecting the Add Data Source option.

    Connect to a Data Source

    1. In the Report Data Source dialog, select the General page and enter the name of the data source.
    2. Under Type, select 'Json Provider'.
    3. Go to the Content tab under Connection and set the type of JSON data to 'External file or URL'.
    4. In the Select or type the file name or URL field, enter the following URL:
      For more information, see the JSON Provider topic.
    5. Go to the Connection String tab and verify the generated connection string by clicking the Validate DataSource Validate Icon icon.
    6. Click OK to save the changes and open the DataSet dialog.

    Add a Dataset

    1. In the Dataset dialog, select the General page and enter the name of the dataset, 'FactSales'.
    2. Go to the Query page and enter the following query to fetch the required fields:  
      Copy Code
    3. Go to the Fields page to view the available fields and modify the Name of the [SalesAmount] field to [Net Sales].
    4. On the same page, add following calculated field:
      Name Value
      Product Category =Switch([ProductKey] < 116, "Audio", [ProductKey] >= 116 And [ProductKey] < 338, "TV and Video", [ProductKey] >= 338 And [ProductKey] < 944, "Computers", [ProductKey] >= 944 And [ProductKey] < 1316, "Cameras", [ProductKey] >= 1316, "Cell Phones")
    5. Click OK to save the changes.

    Create a Chart

    We will use the Chart Wizard dialog to configure chart data values. The wizard appears by default if you have a dataset added to your report. See the topic on Chart Wizard for more information.

    1. Drag-drop Chart data region onto the design area. The Chart Wizard dialog appears with an option to select the data and the chart type.
    2. Select the Dataset Name as 'FactSales' and the Chart Type as 'Column'.
    3. Click Next to proceed. Here, you need to specify the column settings. We will define a data series value to display the net sales values across the horizontal axis. We will later sub-categorize the data series value to form a cluster.
    4. Under Choose Data Values, add a new data value [Net Sales]
    5. In Choose Data Categories, select [Product Category] as the Field.
    6. Click Next and then Finish.

    Add a Text Encoding (Plot Settings)

    1. To open the smart panel for advanced plot settings, right-click 'Plot-Plot1' on the Report Explorer and choose Property Dialog.
    2. In the Chart Pot dialog that opens, go to the Encodings page.
    3. On the Text tab, add a new text encoding and set its properties as below.
      • Expression: =[Net Sales] (to display net sales information for each product category)
      • Aggregate: Sum
      • Target: Label
      • Template Key: NetSales
    4. In the same Chart Plot dialog, go to the Labels page and set the label's properties as below.
      • Template: Net Sales: ${NetSales}
      • Text Position: Outside
    5. Click OK to complete setting up the plot.

    Chart Customization

    See topic Create Clustered Column Chart for chart customizations.

    See Also