Column Repeated Value Highlighting

1.Application scenarios

When designing a report, sometimes you need to check whether there are the same values in the same column. If there are the same values, you need to highlight these values, as shown in the following figure:

2.Implementation ideas

• Use Condition Summary to calculate how many in this column are equal to the current value.

• Use the condition attribute to set the highlighted background color.

1. Data preparation

Create a new ordinary report, create a new data set ds1, the database query statement is:SELECT * FROM EmployeeInformation ORDER BY 2 limit 10,10

2.Report design

1) Design the table as shown below:

2) Select cell A2, select Cell Element>Basic in the property panel on the right, and select the data setting drop-down list.

3) Select cell A2, select the condition attribute in the attribute panel on the right, add a background attribute, and the formula condition is count(A2[!0]{A2=$A2})>1

3.Effect preview

1）PC end:

Save the report, click the Pagination Preview，the effect is as shown in the figure below:

2) Mobile terminal:

Click to download the template:

Column Repeated Value Highlighting.cpt