Solution to Hidden Row Sequence Number Discontinuity

1. Problem description

After using Conditional Formatting> Row Height on the expanded data to hide the rows, the serial numbers that have been compiled before are disturbed. For example, after the data in North China is hidden, the sequence number of the hidden row is also hidden, and the sequence number is broken and displayed, as shown in the following figure:

2. Solutions

Set the sequence number formula in Condition Formatting> New.

1. Prepare data

Create a new report, create a new database query ds1, the SQL query statement is: SELECT * FROM SALES_VOLUME.

2. Design report

Set Sequence in column A, leave cell A2 blank first, and drag the data set field into the table. The table style is as shown in the figure below:

Select cell A2, set its Expansion Direction to V, and the left parent cell to B2. As shown below:

Select cell B2 and set its Data Setting to List. As shown below:

3. Hidden row height

Select cell B2, add a conditional formatting, and set the row height to 0 mm when the cell value is North China. As shown below:

4. Set serial number condition formatting

When the row is not hidden, the sequence number is obtained by directly inserting the formula seq() in cell A2, but when settingConditional Formatting> New for the hidden row, the original formula of the cell needs to be deleted.

The new value is formula seq(), and the condition is  B2<>"North China", that is, the value of cell B2 is not equal to North China. As shown below:

5. Effect preview

1) PC terminal

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

2) Mobile terminal

Both App and HTML5 are supported, and the effect is shown in the figure below:

The completed template can be found at: %FR_HOME%\webapps\webroot\WEB-INF\reportlets\doc-EN\ReportApplication\FeaturesApplication\Solution to Hidden Row Sequence Number Discontinuity.cpt

Click to download the template: Solution to Hidden Row Sequence Number Discontinuity.cpt