I have a layout that is supposed to group sales for the day by agent and prvide the total sales each agent did for that day. When I run the layout I do not get the agent name to print out and the total is the grand total not the sub total for the agent. I used the wizard and an working with the script FM created as part of the wizard. Any suggestions?

Thanks,

Wizbang

The total or subtotal field should be defined as a summary field. At the bottom of the printing or viewing layout put a "layout part" called a "subsummary part" (for discussion purposes the other parts are body, header...). Define the subsummary part as sorted by the agent field (you will have this option when you define the subsummary part). Now put this summary field in the subsummary part on the layout. When you run a sort, the subtotal for each agent will be in the subsummary part.