Add filters to chart data region

Filters on a chart data region in the Bold Reports® Web Report Designer include or exclude specific values. Filters also provide a different view of the dataset in multiple data regions.

In what order are filters processed?

Bold Reports® processes the filters applied in the report parts first on the dataset, then on the data region, and then on groups when it processes the report.

Is there a video?

Yes. Prefer watching over reading? Check out this video on applying filters to a chart data region:

How do I set a filter on a chart category group?

You set a filter on a chart category group from the DATA tab of the Bold Reports® Web Report Designer properties panel.

  1. Select the chart data region in the design area. Filter dialog
  2. Switch to the DATA tab. Filter dialog
  3. In the DATA assign panel, under the column section, click the Settings icon. Filter dialog
  4. Click the Filters... option in the menu. The filter dialog opens, as shown below. Filter dialog
  5. Refer to the Filter Data section, create the required filter expression in the filter dialog, and click OK. Filter dialog

In the above image, the filter equation filters the data in the data region based on the Product Category data field.

What does the filtered chart look like?

On report preview, the Bold Reports® chart displays the sales of Q1, Q2, Q3, and Q4 based on the applied filters and the OrderYear and ProductCategory report parameters.

Filter dialog

Can I filter a chart series group?

Yes. You can set filters on a chart series group in the same way as on a category group.

Download the chart filters report design

See also