Export Utility Calculated Fields

Yahoo Archive
1
You cannot not do aggregate calculations. I think it is expected that you
would be doing that type of calculation and analysis in the software you
will be using with the data. If you out put to Excel it is very simple to
some on a column. If you would be using a dBase program or some other
package there would be nowhere to hold the result of the aggregate field if
is was output using the Export Utility. Remember you are really just
sending out a table of raw data.

Cameron A. Janish
Misha1
866-464-7421
cameron@...
-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Monday, October 01, 2001 12:32 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Export Utility Calculated Fields


Wayne,
Thanks. I was able to add a field label to a calculation as you
mentioned. Two notes about it:

1. I had to enter the field label statement AFTER the "Field Name" in the
calculation, otherwise it stuck the label on the PREVIOUS field's heading in
Excel. So an acceptable statement would be:
OrderRel.OurReqQty column-label "Required Qty"

2. You can do simple sum calculations such as:
OrderRel.OurJobShippedQty + OrderRel.OurStockShippedQty column-label
"Shipped Qty"
but I don't know about "aggregate" calculations. It sure would be nice to
be able to aggregate -- as in combining multiple bin locations in the
PartBin.OnHandQty for instance. Anyone know how to do this in a Vantage
Export?

Troy
----- Original Message -----
From: Wayne Cox
To: vantage@yahoogroups.com
Sent: Friday, September 28, 2001 12:45 PM
Subject: Re: [Vantage] Export Utility Calculated Fields


At 12:32 PM 9/28/2001 , you wrote:
>Now wait a second, Wayne. Where in the world do you put that line? IN
the
>Query statement somewhere?

Oops... sorry. Vantage 4 added calculated fields in the export
utility. Under the fields tab, there is Add and Edit Calculation.
That
whole line I posted was copied from the Edit Calculation box.

Anyone (Lonnie?) know if you can write queries to export only subtotals,
like an aggregate field in RB?

-Wayne



Yahoo! Groups Sponsor
ADVERTISEMENT




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/.
(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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



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


Yahoo! Groups Sponsor
ADVERTISEMENT




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/.
(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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
2
When entering a calculated field in export Utility to Excel the field
name is always "Field1". Is the a way to force a field name.
Russ Dover
IS Manager
Weaver Industries, Inc.
717 336 7507 phone
717 336 4182 fax
rdover@...
www.weaverind.com
3
At 12:02 PM 9/28/2001 , you wrote:
>When entering a calculated field in export Utility to Excel the field
>name is always "Field1". Is the a way to force a field name.

Yes, you can use some of the 4GL display keywords to control the output. I
couldn't find it in the documentation. But if you use the 4.0 ShopVision
reports, they will generate exports that show some of the fancy features
Epicor doesn't tell you about.

Here's a sample of one from the Shipping Performance export definition:

ymd(OrderRel.ReqDate) format "x(10)" column-label "Dimension Required Date"

The column-label keyword will plop that into the top row of your Excel export.

-Wayne Cox
4
Good Question. I would like to know that as well.

Troy Funte

----- Original Message -----
From: Russ Dover
To: vantage@yahoogroups.com
Sent: Friday, September 28, 2001 12:02 PM
Subject: [Vantage] Export Utility Calculated Fields


When entering a calculated field in export Utility to Excel the field
name is always "Field1". Is the a way to force a field name.
Russ Dover
IS Manager
Weaver Industries, Inc.
717 336 7507 phone
717 336 4182 fax
rdover@...
www.weaverind.com

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/.
(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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
5
Now wait a second, Wayne. Where in the world do you put that line? IN the Query statement somewhere?

Troy Funte
Liberty Electronics

----- Original Message -----
From: Wayne Cox
To: vantage@yahoogroups.com
Sent: Friday, September 28, 2001 12:27 PM
Subject: Re: [Vantage] Export Utility Calculated Fields


At 12:02 PM 9/28/2001 , you wrote:
>When entering a calculated field in export Utility to Excel the field
>name is always "Field1". Is the a way to force a field name.

Yes, you can use some of the 4GL display keywords to control the output. I
couldn't find it in the documentation. But if you use the 4.0 ShopVision
reports, they will generate exports that show some of the fancy features
Epicor doesn't tell you about.

Here's a sample of one from the Shipping Performance export definition:

ymd(OrderRel.ReqDate) format "x(10)" column-label "Dimension Required Date"

The column-label keyword will plop that into the top row of your Excel export.

-Wayne Cox



Yahoo! Groups Sponsor
ADVERTISEMENT




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/.
(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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
6
At 12:32 PM 9/28/2001 , you wrote:
>Now wait a second, Wayne. Where in the world do you put that line? IN the
>Query statement somewhere?

Oops... sorry. Vantage 4 added calculated fields in the export
utility. Under the fields tab, there is Add and Edit Calculation. That
whole line I posted was copied from the Edit Calculation box.

Anyone (Lonnie?) know if you can write queries to export only subtotals,
like an aggregate field in RB?

-Wayne
7
Thanks Wayne
That's exactly what I was looking for.
Russ Dover

On 28 Sep 2001, at 12:27, Wayne Cox wrote:

At 12:02 PM 9/28/2001 , you wrote:
>When entering a calculated field in export Utility to
Excel the field
>name is always "Field1". Is the a way to force a field
name.

Yes, you can use some of the 4GL display keywords to
control the output. I 
couldn't find it in the documentation. But if you use
the 4.0 ShopVision 
reports, they will generate exports that show some of
the fancy features 
Epicor doesn't tell you about.

Here's a sample of one from the Shipping Performance
export definition:

ymd(OrderRel.ReqDate) format "x(10)" column-label
"Dimension Required Date"

The column-label keyword will plop that into the top
row of your Excel export.

 -Wayne Cox




Russ Dover
IS Manager
Weaver Industries, Inc.
717 336 7507 phone
717 336 4182 fax
rdover@...
www.weaverind.com
8
Wayne,
Thanks. I was able to add a field label to a calculation as you mentioned. Two notes about it:

1. I had to enter the field label statement AFTER the "Field Name" in the calculation, otherwise it stuck the label on the PREVIOUS field's heading in Excel. So an acceptable statement would be:
OrderRel.OurReqQty column-label "Required Qty"

2. You can do simple sum calculations such as:
OrderRel.OurJobShippedQty + OrderRel.OurStockShippedQty column-label "Shipped Qty"
but I don't know about "aggregate" calculations. It sure would be nice to be able to aggregate -- as in combining multiple bin locations in the PartBin.OnHandQty for instance. Anyone know how to do this in a Vantage Export?

Troy
----- Original Message -----
From: Wayne Cox
To: vantage@yahoogroups.com
Sent: Friday, September 28, 2001 12:45 PM
Subject: Re: [Vantage] Export Utility Calculated Fields


At 12:32 PM 9/28/2001 , you wrote:
>Now wait a second, Wayne. Where in the world do you put that line? IN the
>Query statement somewhere?

Oops... sorry. Vantage 4 added calculated fields in the export
utility. Under the fields tab, there is Add and Edit Calculation. That
whole line I posted was copied from the Edit Calculation box.

Anyone (Lonnie?) know if you can write queries to export only subtotals,
like an aggregate field in RB?

-Wayne



Yahoo! Groups Sponsor
ADVERTISEMENT




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/.
(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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



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