Wiz Bang Computers Posted January 11, 2006 Posted January 11, 2006 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
Oldsneekers Posted January 16, 2006 Posted January 16, 2006 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.
Recommended Posts
This topic is 6887 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now