Counting Rows in Reports

FlexNet Manager Suite 2021 R1.3 (On-Premises)

You can count rows in reports and create subtotals using the ALV Count column.

The report results display in ALV grid lists. You can customize the order of the display, the sorting, and the selection of the columns. In addition, you can save display templates, form sums, and export data for further processing (for example, into Microsoft Excel format). For more detailed information, refer to the SAP documentation.

The report header shows the total number of rows of the report in brackets. The Logon Evaluation and User Data Validation reports contain an ALV Count column in the ALV grid to enable you to create subtotals of report rows.

To count rows in reports:

1. Execute the report. (Refer to the relevant section in this User Guide for more detailed information about the individual reports.)
   Example: Click Reporting, then select Logon Evaluation from the menu. Execute the report.
2. Sort the column that contains the data that you want to count (called column X in this procedure) in descending order.
   Example: Select the Cost Center column and click the Sort in Descending Order button in the Application toolbar.
3. For better visibility, position the ALV Count column and column X next to each other: Select the ALV Count column and drag it next to column X.
4. Select column X and the ALV Count column.
   Example: Hold down the Ctrl key and select the Cost Center column and the ALV Count column.
5. In the Application toolbar, click the Total button. Scroll to the bottom of the list. A yellow row has been added at the bottom and shows the total number of rows in the ALV grid.
6. Again, select column X and the ALV Count column.
   Example: Hold down the Ctrl key and select the Cost Center column and the ALV Count column.
7. In the Application toolbar, click the Subtotals button. Underneath each cost center group, a yellow line displays the subtotal of rows that make up the group.