Empty Data Prompt for a Single Chart

Application Scenario

When the chart has no data, you can customize the prompt for the chart. The setting method in the document Empty Data Hint applies to all charts but does not apply to customizing prompt content for a single chart when the data is empty.

Implementation Method

You can insert a chart and a custom prompt image, when designing a report, and control the display of the chart and image by setting condition attributes.

Data Preparation

Create a general report, and create a database query ds1 with the SQL statement SELECT * FROM Sales_Volume where Region='${Region}'.

Report Design

1. Design the report as shown in the following figure, and the area for the image should be the same as the area for the column chart.

Note:

The image here is customizable and can be replaced as needed.

2. Bind data to the column chart, as shown in the following figure.

3. Select the column chart and set Row Height to 0 when ROWCOUNT("ds1")=0 in Condition Attribute.

4. Select the image and set Row Height to 0 when ROWCOUNT("ds1")>0 in Condition Attribute.

5. Set the parameter panel. The drop-down list of Data Dictionary for the Region parameter is set as the following figure.

Effect Display

1. PC

Save the template and click Pagination Preview. The following figure shows the preview effect.

2. Mobile Terminal

You can click to download the template Empty Data Prompt for a Single Chart.cpt.

Download custom image Custom Image.zip.