Hi,
I have two sections incorporated in my report. One section for Department and the other section for Division. My input parameter is Department. Based on the department, various divisions will be displayed. Each division will have multiple levels. Each level will have several employees.
The report output will have to be displayed as follows:
Section 1: Department = 0026
Section 2: Division = 00261
Level EmplID Illness
00261-1 0001 5
0002 10
00261-1 TOTAL 15
00261-2 010 20
00261-2 TOTAL 20
00261 TOTAL 35
Section 2: Division = 00262
Level EmplID Illness
00262-1 0021 5
0022 10
00262-1 TOTAL 15
00262-2 020 20
00262-2 TOTAL 20
00262 TOTAL 35
--------------------------------
0026 TOTAL 70
I'm encountering a problem getting the Department TOTAL display. This row is repeated in both the divisions, though the value is calculated correctly - the sum of two divisions.
i.e., In the above output, after the division total 00261, I get another row as
0026 TOTAL 70.
Please let me know how to avoid this repeated row in the section total.
Could you please let me know at the earliest?
Thanks,
Anu.
I have two sections incorporated in my report. One section for Department and the other section for Division. My input parameter is Department. Based on the department, various divisions will be displayed. Each division will have multiple levels. Each level will have several employees.
The report output will have to be displayed as follows:
Section 1: Department = 0026
Section 2: Division = 00261
Level EmplID Illness
00261-1 0001 5
0002 10
00261-1 TOTAL 15
00261-2 010 20
00261-2 TOTAL 20
00261 TOTAL 35
Section 2: Division = 00262
Level EmplID Illness
00262-1 0021 5
0022 10
00262-1 TOTAL 15
00262-2 020 20
00262-2 TOTAL 20
00262 TOTAL 35
--------------------------------
0026 TOTAL 70
I'm encountering a problem getting the Department TOTAL display. This row is repeated in both the divisions, though the value is calculated correctly - the sum of two divisions.
i.e., In the above output, after the division total 00261, I get another row as
0026 TOTAL 70.
Please let me know how to avoid this repeated row in the section total.
Could you please let me know at the earliest?
Thanks,
Anu.