I have created a query which has the fields - Alarm Type, which is sorted ascending, Node
Name, and Alarm Count (By Node Name) which is sorted descending. The purpose of the
query is to demonstrate the node which produced the highest type of each alarm. The
query does this fine but, for my report I would like to just show the top 10 of each alarm
type without having to split up the query at all. Is this possible??? I may need to hence that
I already know how to get a top ten of all records, but I would like to get a top ten of each
alarm type within the query results. This could be 35 different alarm types with more than
ten results per alarm type. I would just like to demonstrate the first ten of each alarm type
seeing as i have already sorted the count descending. CAn anyone help???
Name, and Alarm Count (By Node Name) which is sorted descending. The purpose of the
query is to demonstrate the node which produced the highest type of each alarm. The
query does this fine but, for my report I would like to just show the top 10 of each alarm
type without having to split up the query at all. Is this possible??? I may need to hence that
I already know how to get a top ten of all records, but I would like to get a top ten of each
alarm type within the query results. This could be 35 different alarm types with more than
ten results per alarm type. I would just like to demonstrate the first ten of each alarm type
seeing as i have already sorted the count descending. CAn anyone help???
