Report with TOP 108 from each location

[sportsguy]

I have a double column report, 3 down the left and three down the right,
Customer Name, Sales and Ranking (running sum over group on the number 1)and the rankings are of sales in descending order (of course)

I have 130 locations, each with their own 108 Top customers, so each location's page is filled completely, and allows for the same customer with duplicate billing locations (if you wonder why i didn't pick top 100). I have done a single district report, but I can't figure out how to do top 108 customers in descending order for each location in a single report.

I know there is a trick, whether its in vbCode in the report module, or somewhere else. The top 108 is done in the query for the report currently, so that is why i can't get past the first location, but i have removed it, and tried a few other tricks, but evidently, this one requires a magician.

anyone up for the task?

just sort of point me conceptually in the right direction.

thanks

sportsguy

 

[doco]

Research 'Top' keyword in SQL.

SELECT TOP 108 ...
Group By location

Or something like that. Without know more about your data...