To sort groups by the summary, or aggregate, calculation of each group of an Advanced Report, use Top/Bottom filters. Top/Bottom filters look for the highest or lowest values in a set, and then put those values in order. Any arbitrary cell in the report can be the Top/Bottom filter.
If a report has unexpected duplicate values or empty rows, the cause is most likely that there is a one-to-many join to an object not being used.
How to add page numbers to a report.
If the data source returns zero rows, the message below is automatically generated, and report execution will end.
This condition is called No Data Qualified or NDQ. There are a number of ways to handle or prevent this situation:
Enabling filter dependency can prevent improper filter ...
Dealing with situations when reports return no data
No Data Qualified Options
Conditional Row Suppression