Exporting to Excel w/ Vantage 6.10

Yahoo Archive
1
You can use Report Builder to create a delimited file and them import it
to excel as one way.

Another way is with the Buisness Activity Query.

I've actually been taking data strings from Report Builder or Progress
Procedures and creating excel files from the data and also formatting
the cells, create functions, sums, totals, etc. gives me a functional
spreadsheet rather than just imported data filling cells.



Michael Podlin
Network Administrator

V-S Industries, Inc.
900 S. Chaddick Dr.
Wheeling, IL 60090
847-520-1800 x207
Fax 847-520-0269
Michael.Podlin@...




Please consider the environment.
Do you really need to print this email?
________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of craig_4414
Sent: Monday, March 18, 2013 2:58 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Exporting to Excel w/ Vantage 6.10




This capability is available in Epicor 9.05. Unfortunately I'm not using
that version anymore.

In Vantage 6.10 how to I export data into Excel?








[Non-text portions of this message have been removed]
2
This capability is available in Epicor 9.05. Unfortunately I'm not using that version anymore.


In Vantage 6.10 how to I export data into Excel?
3
It's not an ideal solution, but if you preview your report to your screen, you can find the file (RPTxxxxx) that it creates in your local working directory (mfgwrk61 or similiar), then open Excel, open that file name and parse out as needed. It works pretty well unless you have multiple lines in your records.
Or if it is a Report Builder Report, you can export it from there.

Julie Lehmann
Mercury Minnesota Inc.


----- Original Message -----
From: craig_4414
To: vantage@yahoogroups.com
Sent: Monday, March 18, 2013 2:58 PM
Subject: [Vantage] Exporting to Excel w/ Vantage 6.10



This capability is available in Epicor 9.05. Unfortunately I'm not using that version anymore.

In Vantage 6.10 how to I export data into Excel?





[Non-text portions of this message have been removed]
4
You can use Crystal Reports Distribution and then export to excel through
the Crystal really quick. That's what we use all the time.


On Mon, Mar 18, 2013 at 9:58 PM, craig_4414 <craig_4414@...> wrote:

> **
>
>
> This capability is available in Epicor 9.05. Unfortunately I'm not using
> that version anymore.
>
> In Vantage 6.10 how to I export data into Excel?
>
>
>


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



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
craig_4414
Sent: Monday, March 18, 2013 3:58 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Exporting to Excel w/ Vantage 6.10





This capability is available in Epicor 9.05. Unfortunately I'm not using
that version anymore.

In Vantage 6.10 how to I export data into Excel?



No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2240 / Virus Database: 2641/5685 - Release Date: 03/17/13




-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2240 / Virus Database: 2641/5685 - Release Date: 03/17/13

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