Learn how to enable aggregates in applications created with Web Site Factory code generation project and Code OnTime Designer. Aggregates deliver business intelligence and work with adaptive filtering.

Aggregates in ASP.NET/AJAX Web Applications

Here is a snippet of Products data controller that enables aggregates for grid1 view as shown in video.

<view id="grid1" type="Grid" commandId="command1" label="Products">
  <headerText>This is a list of products. </headerText>
  <dataFields>
    <dataField fieldName="ProductName" columns="40" />
    <dataField fieldName="SupplierID" aliasFieldName="SupplierCompanyName" aggregate="Count"/>
    <dataField fieldName="CategoryID" aliasFieldName="CategoryCategoryName" />
    <dataField fieldName="QuantityPerUnit" columns="20" />
    <dataField fieldName="UnitPrice" dataFormatString="c" columns="15" aggregate="Average"/>
    <dataField fieldName="UnitsInStock" columns="15" aggregate="Sum"/>
    <dataField fieldName="UnitsOnOrder" columns="15" />
    <dataField fieldName="ReorderLevel" columns="15" />
    <dataField fieldName="Discontinued" />
  </dataFields>
</view>