Group report. Only the middle row is displayed in the group name segment)

The basic idea is to use a formula field to record the number of records in each group, record the sequence number of the current record with a field, compare two values, and display the first field to suppress! The design process is illustrated in the following example:

1. It is a table of mine. Before designing this item, the style is as follows (note the "type" field in the first column)

2. Create a new formula field named AAA. Enter the formula: Count ({Oi. type2}, {Oi. type1}), which indicates that we use {Oi. the type1} field is a counting condition for {Oi. type 2} field. In fact, we can select a field for statistics on the number of records;

3. Create a New running total field named AAA. Select {Oi as the summary field. type1}, select count for the summary type, and select "when the group is changed" in the reset, the group name will be used by default;

4. Right-click the first field in the detail section ---> Format, select suppress display, and enter the formula:

If mailto: % 7b @ AAA} mod 2 = 0 then
If (# AAA} = round (mailto: % 7b @ AAA % 7D/2) + 1) then false else true
Else if (# AAA} = round (mailto: % 7b @ AAA % 7D/2) then false else true

 
Note: @ AAA is the formula field just created, and # AAA is the total running field just created

5. Run the command again to see if the effect is correct!

 

From: http://blog.csdn.net/xwdd129/archive/2007/08/03/1724872.aspx