Group Report Data

Hossein.K

6,642

Like ( 0 )

Report

1. In Model Editor, expand the AutoDesign1 node.

2. Right-click the Groupings node under the CustTransListTable data region, and then click Add Grouping.

3. Type Group1 as the name.

4. In the Properties window, set the Label property to "=Fields!AccountNum.Value".

5. Right-click the Group on node, and then click Add Group on.

6. Type "AccountNum" as the name.

7. In the Properties window, set the Expression property to
"=Fields!AccountNum.Value".

8. In Model Editor, expand the AutoDesign1 node, and then select the AccountNum field under the Data region.

9. Right-click the Group1 node and then click Properties.

10. In the Properties window, expand the Instance Aggregates, and set Render Location to "GroupFooter".

11. Select the AmountMST field under the Data node.

12. In the Properties window, expand the Aggregation item, and set Aggregate Function to "Sum".

Best Regards,
Hossein Karimi