Embedded SQL

Why does the system force me to include all fields in a group by statement?

I am pulling several fields including two calculated fields (margin and 
margin pct), but by grouping by multiple fields I am not going to see 
everything from low to high on the pct.

As an example, I am pulling the following fields:

invoice number
invoice location
sold to number
gl number (revenue type)
gl desc
extended price
extended cost
margin (calculated)
margin pct (calculated)

I need to group them by the inovice location so that the report does a page 
break after a change in the location, I need to rank them from low to high 
on the pct.

When I ran the query in STRSQL, it runs extremely fast (across a logical) up 
until I add in the group statement and then it required that I add in all 
seven fields (with the exception of the calculated fields)....which then 
throws off my grouping.....

Any suggestions ?????


If you bought it, it was hauled by a truck - somewhere, sometime.