Shulou(Shulou.com)06/01 Report--

What this article shares with you is about how to merge cells with the same value into a large cell in the big data report. The editor thinks it is very practical, so he shares it with you. I hope you can get something after reading this article. Let's take a look at it with the editor.

There are generally two cases of merging cells with the same value:

1. One is a relatively simple case: merging the same value of the classification or classification extension fields (as shown in the following figure: merging the supplier data with the same value)

In this case, most reporting tools can directly support it, using the grouping function.

2. The other is a more complex situation: what is to be merged at this time is not grouping fields, but dynamic merging of a single-valued data (as shown in the following figure: merging cells of the same drilling status in different months)

In this case, many report tools do not support it, and you have a lot of trouble to do it yourself. the general code logic is: first read all table data, and then find cells with the same value in accordance with the row / column. Merge cells with the same value to return to an object, and finally re-render the table to show the effect of the merged cells.

The above is how to merge the cells of the same value into a large cell in the big data report. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.