Exago .NET API Documentation
IsAggregateAndGroupInDatabase Property
WebReports.Api.Common Namespace > General Class : IsAggregateAndGroupInDatabase Property

If True, aggregate and grouping calculations will be done in the database when possible. This will provide a performance boost for reports with group sections.

Before enabling this, you must ensure that all One-To-Many Joins in your environment are correctly identified and set as One-To-Many in the Join options menu. If these joins are not properly identified, reports which utilize them will return incorrect aggregate data. See Database Aggregation for more information.
Syntax
public System.bool IsAggregateAndGroupInDatabase {get; set;}

Property Value

True or False as described above.
Remarks
Same as setting Admin Console > General > Database Settings > Aggregate and Group in Database.
See Also

Reference

General Class
General Members

Exago Knowledge Base

Roles
Database Settings

 

 

Version: 2021.2.6 Last published: 5/18/2022

Contact Exago Support