[Original] Web report development technology Topic 1: Sequence Number Problem

Recently, I have accumulated some experience and experience in using C # To implement web reports. I have also written an introduction Article, but some netizens have not made it clear. I think that I want to use a single article to illustrate that Web report development will inevitably be big and empty, and will not fall into the category. Therefore, I think that every article only pays attention to one aspect of Web report development. Multiple Articles form a series of web report development articles. These series of Web report development articles have no order, and are divided into master and slave. Every article only looks at Web report development from a perspective. You can select only the parts you are interested in, which can save your time. This is the origin of the Web report development technology topic. Today, let's start with a small serial number!

Web report development technology Topic 1: Sequence Number

In Chinese reports, we often see 1, 2, 3, 4... in cells .... In a row or column. This is the serial number. Obviously, these sequence numbers do not exist in the data source. Therefore, the Web report development tool needs to calculate them according to certain rules. Sequence numbers in reports are often ignored by some common Web report development tools. Sometimes, a sequence number is forced to write code because it cannot be generated, which greatly limits the efficiency of Web report development.

You will understand what you need to study. Next let's take a look at the general sequence numbers in Chinese reports?

* Fixed sequence number:That is, the fixed sequence number value in the table does not change with the amount of data content. This is the easiest way to simply enter the sequence number value in the table.

* Dynamic sequence number:That is, the sequence number value is not fixed and depends on the data in the data source. For example, if the number of records is 8, the sequence number ranges from 1 to 8.

* Chinese Character serial number:Because we are Chinese, serial numbers are often expressed in the form of one, two, three, and four, which requires converting numbers into Chinese serial numbers. Sometimes brackets (for example, (1) or comma (for example, 1) are added to the serial number.

* Horizontal sequence:Sequence numbers are arranged vertically and horizontally.

* Multiple column numbers:A group report is one of the most commonly used reports. Therefore, a sequence number is generated for each group field.

* Serial number of a cross-row:Grouping reports usually have subtotal rows. If the number of subtotal rows does not exist, the number must be skipped.

* Extension of serial number---Sequence Value:Sometimes there are sequence values such as A, B, and C in the report. This can also be considered as a sequence number.

Text is a bit empty. The following figure shows the text:

 

 

In this report, there are three sequence numbers: total sequence number, region sequence number, product sequence number, and total sequence number, which are the sequence numbers starting from 1, the region serial number is the sequence number starting from 1 for each region, and the product serial number is the sequence number starting from 1 for each product in each region. This is a typical multi-column serial number report.

 

 

In this report, the sequence number of the red word is cross-Subtotal rows, that is, there is no sequence number in the subtotal rows. This is a typical report of serial numbers across rows. At the same time, the serial numbers of the blue-colored characters in the second row of the report are arranged horizontally. Each region has a sequence number. This is a typical report with dynamic sequence numbers and serial numbers arranged horizontally.

 

 

In this report, there are Chinese Character serial numbers: first, second, and (1) serial numbers. There are also serial number nesting and multiple layers.

The above is the serial number form in the Web report that I think of, and I hope you can add it. The above shows the possible sequence numbers in Chinese-style reports, which is equivalent to the serial numbers required for Web report development. The following describes how to design and implement these sequence numbers in Table E.

To solve the complex sequence number problem in Table E, you need to extract these requirements and summarize the report formulas to be set. Then, you can combine these formulas based on your needs. Of course, these formulas are not specifically set to solve the problem of serial numbers.

The following formulas may be used to solve sequence numbers in Table E:

Row () returns the current row number.

COL () returns the current column number

& B1 returns the group number, or the number of cells extended by B1.

DS. Count () returns the total number of each group in the group, or returns the number of extended cells of an extended cell.

Tochinese () from 1, 2, 3... Convert to one, two, three ....

Map () shows the value comparison to convert the table function, for example, converting 1 to A, converting 2 to B, and so on.

How can we use these functions to solve the sequence number problem. If you want to study the report in depth, you can try it online on the website of Fancheng or download it to your local computer, the example shows the running effect and how to use these functions to obtain the sequence number you want.
Related links:
Web report development technology Topic 2: report tool core-dataset Transformation
Web report development technology Topic 3: irregular grouping and cross-row group operations
Tabulation Efficiency Analysis of Web report tools

Note: this series of articles is self-original and first published in the blog Park. Please indicate the source for reprinting.