Running a report is a great tool. however, if you use the sum option and then try to select the sum, it will only highlight one of the sum in the view rather than all of the sum.

ie i have 3 door types

door 01 = 10

door 02 = 20

door 03 = 15

if i create a report to sun me the Sums and then select the sum line in the detail dialog, it only highlights one of the sum.

i want to highlight ALL of the sum ie all of door type 01