Query Designer - Group by

Yahoo Archive
1
Sorry... BAQs have a few edges over SQL - but this isn't one of them. No Group By-like summary capability.

(If the full power of Progress was enabled instead of the dumbed down BAQ editor/interpreter version, I might even say Progress is more powerful than SQL - but they hide the power from you and we'll just never know.)

Rob




________________________________
From: tomrippity02 <bateman_aaron@...>
To: vantage@yahoogroups.com
Sent: Friday, September 11, 2009 11:59:39 AM
Subject: [Vantage] Query Designer - Group by

Â
I'd like to do a group by in the query designer. I have a query that pull part cost, on hand quantity and a few other things. The problem I have is that if I have an item in multiple warehouses, it splits the quantity on hand into 2 or more rows, 1 for each warehouse. If I could do a sum of the part quantity and group by the other fields, i'd be set.

ideas?







[Non-text portions of this message have been removed]
2
I'd like to do a group by in the query designer. I have a query that pull part cost, on hand quantity and a few other things. The problem I have is that if I have an item in multiple warehouses, it splits the quantity on hand into 2 or more rows, 1 for each warehouse. If I could do a sum of the part quantity and group by the other fields, i'd be set.

ideas?