-
March 26th, 2009, 05:36 PM
#1
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 05:44 PM.
-
January 18th, 2010, 10:38 AM
#2
Re: summarizing info without grouping
If you look at the "SQL" for your query, add "distinct" to the select statement.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|