There is a table with a bunch of orders and another that has the various companies' information. I make a report which shows all the orders made by which customers (1 line for each order) and group them according to city of company. So the only problem is that I don't want to see a line for each order but rather a line for each company with their total in purchases.
This total information is not found in the database. So anyone know how I can get that data to fit on one line without having to use sql?
I figured this out I am kind of silly about not being able to see that. Use a nested grouping and include summary information for that second grouping. I grouped the second according to the company.
Last edited by fa1512; March 26th, 2009 at 05:44 PM.