Business Activity Query Vantage 6.0

Yahoo Archive
1
Thanks for the reply,Aaron.
I guess this is another one of those Vantage "features" you expect
more of.....
Joey
2
Does anyone know how to "Add Calculation" from the 'Fields' tab when
you are creating a query?? This must be some kind of Progress code
and Epicor hasn't been very helpful about providing any sample code.
If you have any sample code calculating SUM or COUNT, I'd sure
appreciate getting a copy of it!
Thanks! -Joey
3
Joey,



With this being a query and not a report, you can't aggregate, only
calculate. For instance you can...

OrderRel.SellingReqQty - OrderRel.SellingStockShippedQty -
OrderRel.SellingJobShippedQty column-label "Remaining"...

But you can't total or count the number of "OrderRel.SellingReqQty" as
that would not be a column but would be a total based on a column.

If I am incorrect in my understanding, someone please correct me.



Aaron Hoyt

Hittite Microwave Corporation



-----Original Message-----
From: joeyloken [mailto:joeyloken@...]
Sent: Tuesday, February 03, 2004 11:42 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Business Activity Query Vantage 6.0



Does anyone know how to "Add Calculation" from the 'Fields' tab when
you are creating a query?? This must be some kind of Progress code
and Epicor hasn't been very helpful about providing any sample code.
If you have any sample code calculating SUM or COUNT, I'd sure
appreciate getting a copy of it!
Thanks! -Joey



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links



_____

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
<http://docs.yahoo.com/info/terms/> Service.



[Non-text portions of this message have been removed]