Add an Exploded Pie Chart in the Bold Reports^® Web Report Designer

You add an Exploded Pie Chart to a report in the Bold Reports^® Web Report Designer by dragging it from the item panel. Use it to show a pie chart in which one or several slices are separated from the others.

How do I add an exploded pie chart to the report?

The Bold Reports^® Web Report Designer lists the exploded pie chart under the Proportion category in the item panel.

Drag and drop the exploded pie chart from the item panel into the design area.

The exploded pie chart renders in the design area, and the properties panel lists the chart properties.

How do I create data for the exploded pie chart?

To present data in a Bold Reports^® exploded pie chart, create a dataset and bind data to the chart data region. This example uses the following JSON data to create the dataset.

[
  {
    "Browser":"Chrome",
    "Percentage":37
  },
  {
    "Browser":"UC Browser",
    "Percentage":17
  },
  {
    "Browser":"iPhone",
    "Percentage":19
  },
  {
    "Browser":"Others",
    "Percentage":4
  },
  {
    "Browser":"Opera",
    "Percentage":11
  },
  {
    "Browser":"Android",
    "Percentage":12
  }
]

For more information, see Create an embedded dataset. This example creates a dataset using JSON inline data to design the report.

How do I assign data to the exploded pie chart?

The Bold Reports^® Exploded Pie Chart needs a minimum of 1 value element and 1 column element to render. Drop the measure or expression field you want to analyze into the Y value(s) section. Drop the dimension that categorizes the measure onto the Column section. To categorize by a series, also drop the respective dimension onto the Row(s) section.

To configure data in an exploded pie chart, follow these steps:

1. Select the chart report item in the design area to bind data to it.

2. Click the Properties icon in the configuration panel to open the property pane. Then, switch to the DATA tab.

   

3. Choose a dataset in the dropdown list. The dropdown lists the data available in the report.

   

4. Review the fields. The Measures section lists numeric columns and numeric expressions. The Dimensions section lists other types of columns and dimension expressions.

   

5. Drag and Drop Measure Element:

   Drag the numeric column (measure element) or the numeric expression column from the Measure section and drop it in the Y Value(s) section.

   

   The following image shows the report item design after you add the Y value field.

   

6. Aggregate Options:

   Click the Settings icon (highlighted in the image) to open the aggregation type dropdown list.

   

   Set the aggregation type that computes the selected column.

   

7. Drag and Drop Dimension Element:

   Drag the dimension element from the Dimensions section and drop it into the Column section. The dimension measures against the numeric column(s) selected in the Y Value(s) section.

   

   The following image shows the report item design after you add the dimension field.

   

8. Grouping:

   You can also group the added column element with another column by adding the respective dimension element into the Row(s) section.

9. Formatting Column and Row(s) sections:

   You can also Filter, Sort, or Group the Column or Row(s) sections using expressions.

How do I format the exploded pie chart?

You format an exploded pie chart in the Bold Reports^® Web Report Designer through the settings in the Properties tab.

To format an exploded pie chart, follow these steps:

1. Drag and drop the exploded pie chart into the design area and resize it to the required size.

2. Configure the data for the exploded pie chart.

3. Select the exploded pie chart and click the Properties icon in the configuration panel to open the property pane.

   

The property pane lists the properties available for the report item with their default values.

Name

The Name property provides a unique name for the exploded pie chart item in the report.

Basic Settings

The Basic Settings category of the exploded pie chart contains the Show Legend and Choose Series properties shown in the following image.

Show Legend

A chart legend is text that describes the plotted data. You can toggle the visibility of the legend in the chart and customize the legend text appearance. To set or reset legend properties, see the Show Legend property.

Choose Series

The exploded pie chart lists all series you add in the Choose Series dropdown. To customize a series appearance, choose the required series name in the dropdown.

In this example, the Data Label Settings properties have the Show Data Label property enabled and the Label set to #PERCENT.

To customize each series using the properties panel, see Series.

Appearance

The exploded pie chart Appearance properties (border style, color, width, and background color) style the chart and customize its appearance in the report design. The properties panel lists these properties under the Appearance category.

Chart Area

The exploded pie chart Chart Area property customizes the area of the chart design.

Use the Color Palette property to customize the color of the chart. The Color Palette property is listed under the Chart Area category.

In this example, the Color Palette is set to Pacific. The following image shows the design.

Title

To show or hide the exploded pie chart title, toggle the Show Chart Title checkbox. Customize the Chart Title by editing the Title Text property of the chart. You can customize the font color, font text, font style, border, background, and position of the title in the chart design.

No Data

The exploded pie chart No Data property displays static text when a dataset returns empty or zero rows at runtime.

To set or reset no data message properties, see the No Data Message property section.

Page Break

The exploded pie chart Page Break property controls the amount of information on each page when you preview the report. To apply the page break property to the chart report item, follow these steps:

1. Choose a Break Location type in the dropdown. The Break Location property specifies where the page break occurs.

   

2. To prevent predefined page breaks from being applied during report preview, enable the Break Disabled property checkbox. You can also control page breaks during report preview with expressions. For details on setting and resetting page breaks dynamically, see the Set Expression and Reset Expression sections.

   

3. To restart page numbering on each page, enable the Page Number Reset property checkbox.

   

Data Element

The exploded pie chart Data element properties control the visibility of a report item when you export the report in XML format. The properties panel lists them under the Data Element category.

Name

The Name field assigns a custom name to the chart element. The chart report item exports with the provided name.

Note: The name cannot contain spaces, and it must begin with a letter followed by letters, numbers, or the underscore character (_).

Output

The Output property controls the visibility of the chart when you export the report. Each option performs the following operation:

• Auto or Output - Exports the chart report item.
• NoOutput - Does not export the chart report item.

Miscellaneous

The exploded pie chart Miscellaneous category contains the page name, tooltip, document map, bookmark, and custom style properties.

Page Name

The Page Name property names the first worksheet of the Excel workbook when you export the report to Excel format.

You can set static or dynamic text as the page name. To set and reset dynamic text, see the Set Expression and Reset Expression sections.

Tooltip

The Tooltip property displays informative text or values when the user hovers over the report item in the report preview. To set a tooltip for a chart item using the properties panel, see the Tooltip section.

Document Map

A document map is a navigational feature that displays a separate side pane with a set of navigational links in a hierarchical structure when you view a report. A user can click the content in the list to navigate to the report page that displays that item. To configure the document map in the report design, see the Document Map section.

You can set static or dynamic text as the value for the document map property. To set and reset dynamic text, see the Set Expression and Reset Expression sections.

Bookmark

Bookmark links let users navigate to different parts of an SSRS report. You can add bookmarks to each textbox, image, table, or chart, or to the unique group values displayed in a tablix, to direct users to specified locations in the report. The value of the bookmark property can be your own strings or an expression. To configure bookmarks in the report design, see the Bookmark section.

You can set static or dynamic text as the value for the bookmark property. To set and reset dynamic text, see the Set Expression and Reset Expression sections.

Custom Style

The Custom Style property enables external CSS for styling report items, giving more flexibility than the built-in styling options. Use this property to meet specific design requirements and keep styling consistent across multiple reports. For a step-by-step guide on setting up custom styles in your report, see the How To section of this guide.

How do I preview the exploded pie chart report?

You preview the exploded pie chart report from the design view of the Bold Reports^® Web Report Designer.

1. Review the final design view of the report, shown in the following image.

   

2. Preview the report. The following image shows the report preview.

   

Download the exploded pie chart report design file from GitHub.

Frequently asked questions

Where is the exploded pie chart in the item panel?

The Bold Reports^® Web Report Designer lists the exploded pie chart under the Proportion category in the item panel.

What data does an exploded pie chart need?

The exploded pie chart needs a minimum of 1 value element in Y value(s) and 1 column element in Column.

See also

• Pie chart
• Chart data labels
• Chart series properties
• Chart color palette