TOP X reports
A specific type of report you are sometimes asked to produce is the TOP X report. For example, a report containing sales revenue by salesperson where the data is not just a list of numbers sorted alphabetically but by sales revenue from highest to lowest, to see who is really performing in a certain period.
To be able to achieve this goal, you will need to sort and filter the data in your report.
Sorting is organizing report data in a certain order and filtering is about eliminating unwanted information within a report. The sort order you define in the Visual Studio Report Designer will take precedence over the order in which the dataset is generated/sorted.
Tip
Sorting and performance
Sometimes, students believe that because the sorting in Visual Studio overrides the sorting of the data items, that the data item should not be sorted at all because that would consume unnecessary resources. In fact, this is not true. It might very well be that you select a key for a data item ...
