Changes

Creating Summary Reports

340 bytes added, 16:38, 2 May 2014
Using Group By
The options available in this combo box are as follows:
'''Standard'''
* '''Group By''' - Groups the selected records by that column. You will usually use this option in addition to one of the other options applied to other fields.
* '''Sum''' - Total of a numeric field.
* '''Count Distinct''' - Count the number of distinct occurrences.
* '''Average''' - The average of a numeric field.
* '''Standard Deviation''' - The standard deviation of a numeric field.
 
'''Total Group Options''' - ''See [[Using Total Group Options in Report Builder]] for details.
* '''Total Group By'''
* '''Total By Sum'''
* '''Total By Count'''
* '''Total By Average'''
* '''Total By Standard Deviation'''
* '''Display Total Label'''
==Using the Count Option==
8,849
edits