Hey all:
I have a small sales tracking application that is supposed to generate a few reports. I currently have the following query pulling data for my report:
SELECT
deals.name AS `Client Name`,
`state`.Name AS `State`,
deals.months AS `Program Lenght`,
deals.pull AS `Monthly Enrollment Fee`,
deals.eFee AS `Total Enrollment Fee`,
agents.Name AS `Sales Person`
FROM deals
INNER JOIN agents ON deals.agent = agents.id
INNER JOIN `state` ON deals.`state` = `state`.iD
WHERE
month(deals.adddate) = month(current_DATE)
It outputs all the data that I wish to have visible, I then go and setup Sales Person as my Group Field, interval Normal with a summary. I also have "Show Global Summary" and "Show details and summary" checked. I have it setup to display all the fields, then min/max/sum/avg for deals.pull and deals.eFee. When I run the report it properly shows the GLOBAL sum/min/max/avg but does not show the per-grouping (in this case sales agent). What am I missing or doing wrong here?
