I am using the following datashaping in my asp page just fine until I try to add the Aggregate COUNT function which generates the error below. I want to get a count of the number of Districts withing each Division.

SQL = "SHAPE {Select DivName from tblDiv ORDER BY DivName ASC} APPEND ({Select DistrictName as DS From tblDistrict ORDER BY DistrictName} As rsDS RELATE DvID TO DvID) As rsDV
, COUNT(DS) AS CDS"
dim rsDS
set rsDS = Server.CreateObject("ADODB.Recordset")
rsDS.Open SQL, cn

Error Type:
MSDataShape (0x80040E14)
Aggregate functions require a chapter column. The column (DS) is not a chapter column or does not exist.

My data connection contains:
Provider=MSDataShape; Data Provider=SQLOLEDB