• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• Aggregate functions and groups with Ado Shape Commands. You can use the opened resultset with Data

Aggregate functions and groups with Ado Shape Commands. You can use the opened resultset with Data

Aggregate functions and groups with Ado Shape Commands. You can use the opened resultset with Data Report Designer in order to build groupped

Rate Aggregate functions and groups with Ado Shape Commands. You can use the opened resultset with Data

• 1
• 2
• 3
• 4
• 5

(3(3 Vote))

    Set db = New Connection
    db.CursorLocation = adUseClient
    db.Open "PROVIDER=MSDASQL;dsn=yourDSN;uid=;pwd=;"
    sql = "SHAPE {SELECT * FROM YOUR_TABLE}  AS YOUR_GROUP COMPUTE YOUR_GROUP, 
        SUM(YOUR_GROUP.FIELD1) AS SUM1, COUNT(YOUR_GROUP.FIELD2) AS COUNT1 BY  YOUR_FIELD_GROUP"
    aRec.Open sql, db
    Set dataReport.DataSource = aRec
    dataReport.Show