March 26th, 2009, 06:36 PM
summarizing info without grouping
How the database is organized.
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 06:44 PM.
January 18th, 2010, 10:38 AM
Re: summarizing info without grouping
If you look at the "SQL" for your query, add "distinct" to the select statement.
Tags for this Thread
Click Here to Expand Forum to Full Width