We use ASP-DB gold on Windows 2003 and NT Servers, querying against a Teradata DB. When running an aggregate query, the displayed table only returns the number or rows that equal the value of the aggregate in the first row of the result set.

For example if results set is:

Staff AggregateValue
Bob 5
Mary 19
Gus 62

The table will display 5 rows and the footer summary will show 1-5 of 5. If we eliminate Bob in the SQL query, the table will diplay 19 rows and the footer 1-19 of 19. If we drop Mary and Bob from the query, the table will display 1-44 of 44 because Gus's aggregate total is greater than the total number of rows returned (44).

Why is ASP-DB using the first row aggregate value in the result set as the row count of the result set?