I have a report based on a query. The query pulls commissions data along with employee data, marries the data up, does some calculations and spits out the results.
I want the report to spit out "statements" by person so that I can consolidate into a master for each person and ship off to SharePoint.
My first report, however, is only providing 1 person, not the rest.
I tried to use the grouping and sorting, didn't work.
I tried removing group/sort, that didn't work either, obviously.
Not sure what I did - was working before ...