I have a detail query that pulls one salesperson, their customers and their sales for the month. Now I want to add a summary page that has a list of all salespeople and the total for the month.
I tried creating a second query and postioned the detailed query just to the right of it. I then only pulled the 'salesperson', and 'total(month)' data items. This isn't working for some reason. It just pulls zeros. Any ideas?
It sounds like you need a master (summary) detail(individual salesperson) type of report in which you would be creating a master detail link on the salesperson id
you can use the same query itself create a data item formula to something like Total(Sales) for month and than in your summary report only drag the salesperson name along with this data item which would giving you monthly aggregated values