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

In banking, finance, sales and other systems, we often see such a kind of statements, they are generally inherited from the original manual report era, need to be printed on fixed-size paper, with fixed style requirements. The specific forms include various registers and bills, etc.

Before there was no reporting tool, most of these reports were made using Excel, which was time-consuming and laborious and difficult to maintain, and worked late alone every time (a cool song for myself). Today, I'm going to take a new rhythm and show the magic operation to make this kind of document report.

This time we take the provident fund documents to demonstrate the specific operation. The following picture is the payment documents provided by the provident fund management center for each unit. it is generally required that there is unit information at the top of each page of the documents, and the specific provident fund payment details of the unit staff are filled in in the middle, with the total and signature information at the bottom. The nostalgic feature of a manual era is that only seven pieces of data are displayed on each page, and if you fill in more than seven lines on the next page, you have to fill in blank lines even if there are less than seven lines on one page, and it exactly corresponds to the size of the paper document format:

Well, in order to get off work on time, let's get started with the drying report:

First, draw the report style and framework according to the effect picture, as shown in the following figure:

[practical tips] because document reports basically need to be printed on fixed-format documents, that is, commonly known as "set-up", it is necessary to design the report according to the actual documents. The specific approach is: scan the document picture with the scanner, and then resize the picture and set it to the background map of the report (report properties-> other-> background map), so that you can adjust the cells of the report compared to the border of the picture.

Next, design a fixed data area:

According to business requirements, lines 1 to 8 and lines 11 to 14 are required to be displayed on every page, so we need to achieve this effect through row property settings:

Rows 1-8 need to be designed as grouping headers. Lines 11 to 14 are set to the end of the report.

After setting up, it is shown in the following figure:

Then, the detail data association calculation

The business requires that the details be displayed in groups according to the serial number, so we add the corresponding cell expression and do data association.

Among them

A1:=hnszgrkhdjqc.group (serial number; serial number: 1). After merging cells, the first eight rows of data follow the serial number to dynamically display records. If D4 and D5 cells need to fetch numbers from the data set, you can directly use the value expression.

B9:=hnszgrkhdjqc.select (id), and set the left nominative to A1, which means to follow the serial number dynamically.

C9:=&B9, and set the left nominative to B9, which is the fixed usage of serial number implementation.

We can directly use the value expression after D 9, that is, the dataset. Field name

Finally, the blank line effect is realized perfectly.

To achieve a fixed display of 7 pieces of detail data per page, and to make up for less than 7 rows, this needs to be divided into two steps:

1. Fill in the blank lines:

We insert a row in the 10th line, edit the blank line expression C10:=to ((hnszgrkhdjqc.count ()% 7) + 1 Magne7), and judge whether it is made up according to the number of records. Here, we need to follow the serial number to judge, so we need to set the left nominative of A10 to A1.

In particular, when the number of records reaches 7 lines, it will also be extended. In this case, the extra extended lines need to be hidden, as shown in the following figure (using hidden line expressions):

two。 For the effect of fixed 7 lines per page, we can achieve the effect of paging after the line + paging by paper:

In the report properties-"paging, set to page by paper, and the paper size is set according to the actual business requirements

Find the "paging after line" property configuration in the cell property on the right side of the C10 cell, and add the expression: if (D1% 7 records 0 #), which means that if the number of data records in the group is divisible by 7, then it is hidden, otherwise the expanded data will be displayed.

All right, a perfect document report is complete. Let's review the problems encountered and the skills to solve them:

1. The fixed header and footer display of each page

[tip] set row properties to grouping header and report footer

two。 Fill in the blank lines to ensure a fixed number of detailed data per page

[tips] use the to () function and dynamic hidden lines to fill in blank lines, and use the post-line paging function to achieve a fixed number of lines paging effect

At this point, the document report production is completed, we only use the left nominative and post-line paging function to make the document report, this wave of operation 6 is not 6? Money orders, account opening orders, warehouse entry and exit orders of Shenma Bank are all so easy. Come and join the embellish family and work overtime say byebye from now on.

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.