Create Grouped Or Summary Report. To begin the analysis from the menus choose. In the Navigation Pane select a table or query that contains the records you.
In the Navigation Pane right-click the report and then click Design View. On the Design tab in the Controls group click Text Box. Basically it goes please forgive the blatent craziness of the SaleDate table but Im simplifying the business logic and in reality it actually makes sense to have it this way SELECT agentName SUM salesAmount AS Gross SUM salesAmount salesCommission AS Commission FROM agent INNER JOIN.
DataTable1Groupname is your require group for that.
In the Navigation Pane right-click the report and then click Design View. Create formula field. We can display the Row Groups panel by selecting the menu item View Grouping Figure 29 Display the Row Groups Panel. Basically it goes please forgive the blatent craziness of the SaleDate table but Im simplifying the business logic and in reality it actually makes sense to have it this way SELECT agentName SUM salesAmount AS Gross SUM salesAmount salesCommission AS Commission FROM agent INNER JOIN.