>I also have a user who can run some (but not all) report builder reports
>to generic text successfully.
My knowledge of windows printing isn't all that deep... but from what I
know, the application "asks" the print driver about its capabilities,
including the fonts it can print. Normally the generic driver reports that
it only does 10cpi fixed font. If the fonts specified in the report aren't
supported, it looks for a close match and may use an alternate.
If you look in the properties for the generic printer, there are blank
fields to specify the control characters to select different fonts. If you
fill something in there (like just a space) then it will report that it
supports more fonts, and you may see more of the output from the report.
Good morning all,
Â
Is anyone aware of how to export the Production Mgmt/Job Mgmt/Reports/Work
In Process report into Excel?
Â
Bosses request of course and the Vantage people scratched theirs heads and
promise to let me know :-)
Â
Thank you,
Daniel C. Spoerl
Estimator/MIS
Toledo Metal Spinning Co.
Phone: (419) 535-5931 ext. 203
Fax:Â Â Â (419) 535-0565Â
Personal E-fax: (707) 897-1708Â
Email:Â Â Â HYPERLINK
"mailto:dans@..."dans@...
WebSite: HYPERLINK
"http://www.toledometalspinning.com/"http://www.toledometalspinning.com
HYPERLINK "http://www.toledometalspinning.com/products_configurator.htm" \n
Â
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.336 / Virus Database: 188 - Release Date: 3/11/2002
[Non-text portions of this message have been removed]
I preview the report in Vantage, open the .rpt file it creates in the local
vntgwork directory in XL and edit from there.
HTH Chris Reed
PWSL
-----Original Message-----
From: dans@... [mailto:dans@...]
Sent: Thursday, March 14, 2002 1:37 PM
To: Vantage Group (E-mail)
Subject: [Vantage] Exporting WIP report to Excel
Good morning all,
Â
Is anyone aware of how to export the Production Mgmt/Job Mgmt/Reports/Work
In Process report into Excel?
Â
Bosses request of course and the Vantage people scratched theirs heads and
promise to let me know :-)
Â
Thank you,
Daniel C. Spoerl
Estimator/MIS
Toledo Metal Spinning Co.
Phone: (419) 535-5931 ext. 203
Fax:Â Â Â (419) 535-0565Â
Personal E-fax: (707) 897-1708Â
Email:Â Â Â HYPERLINK
"mailto:dans@..."dans@...
WebSite: HYPERLINK
"http://www.toledometalspinning.com/"http://www.toledometalspinning.com
HYPERLINK "http://www.toledometalspinning.com/products_configurator.htm" \n
Â
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.336 / Virus Database: 188 - Release Date: 3/11/2002
[Non-text portions of this message have been removed]
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 http://docs.yahoo.com/info/terms/
Excellent Chris, thank you so much, works well.
Â
Dan
-----Original Message-----
From: Chris Reed [mailto:chrisr@...]
Sent: Thursday, March 14, 2002 9:04 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Exporting WIP report to Excel
FYI
I preview the report in Vantage, open the .rpt file it creates in the local
vntgwork directory in XL and edit from there.
HTHÂ Â Chris Reed
PWSL
-----Original Message-----
From: dans@... [mailto:dans@...]
Sent: Thursday, March 14, 2002 1:37 PM
To: Vantage Group (E-mail)
Subject: [Vantage] Exporting WIP report to Excel
Good morning all,
Â
Is anyone aware of how to export the Production Mgmt/Job Mgmt/Reports/Work
In Process report into Excel?
Â
Bosses request of course and the Vantage people scratched theirs heads and
promise to let me know :-)
Â
Thank you,
Daniel C. Spoerl
Estimator/MIS
Toledo Metal Spinning Co.
Phone: (419) 535-5931 ext. 203
Fax:Â Â Â (419) 535-0565Â
Personal E-fax: (707) 897-1708Â
Email:Â Â Â HYPERLINK
"mailto:dans@..."dans@...
WebSite: HYPERLINK
" HYPERLINK
"http://www.toledometalspinning.com/"http://www.toledometalspinning.com/"
HYPERLINK
"http://www.toledometalspinning.com"http://www.toledometalspinning.com
HYPERLINK " HYPERLINK
"http://www.toledometalspinning.com/products_configurator.htm"http://www.tol
edometalspinning.com/products_configurator.htm" \n
Â
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system ( HYPERLINK
"http://www.grisoft.com)."http://www.grisoft.com).
Version: 6.0.336 / Virus Database: 188 - Release Date: 3/11/2002
[Non-text portions of this message have been removed]
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:
HYPERLINK
"http://groups.yahoo.com/group/vantage/files/."http://groups.yahoo.com/group
/vantage/files/.
(2) To search through old msg's goto:
HYPERLINK
"http://groups.yahoo.com/group/vantage/messages"http://groups.yahoo.com/grou
p/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
HYPERLINK
"http://groups.yahoo.com/group/vantage/links"http://groups.yahoo.com/group/v
antage/links
Your use of Yahoo! Groups is subject to HYPERLINK
"http://docs.yahoo.com/info/terms/"http://docs.yahoo.com/info/terms/
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: HYPERLINK
"http://groups.yahoo.com/group/vantage/files/."http://groups.yahoo.com/group
/vantage/files/.Â
(2) To search through old msg's goto: HYPERLINK
"http://groups.yahoo.com/group/vantage/messages"http://groups.yahoo.com/grou
p/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: HYPERLINK
"http://groups.yahoo.com/group/vantage/links"http://groups.yahoo.com/group/v
antage/links
Your use of Yahoo! Groups is subject to the HYPERLINK
"http://docs.yahoo.com/info/terms/"Yahoo! Terms of Service.
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.336 / Virus Database: 188 - Release Date: 3/11/2002
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.336 / Virus Database: 188 - Release Date: 3/11/2002
[Non-text portions of this message have been removed]
Unbelievable, Chris. Brilliant in its simplicity. It's a great hack!
It'll appear on the Epicor website tomorrow as an undocumented Vantage
feature, I suspect. I love it!
I happened to be needing to get something from Vantage into Excel just as
you sent the message. Thanks. This is one I'll take with me for sure.
...and this year's Vantage "Great Hack" award goes to... Chris Reed.
Gary Polvinale
Denton ATD
-----Original Message-----
From: Chris Reed [mailto:chrisr@...]
Sent: Thursday, March 14, 2002 9:04 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Exporting WIP report to Excel
FYI
I preview the report in Vantage, open the .rpt file it creates in the local
vntgwork directory in XL and edit from there.
HTH Chris Reed
PWSL
-----Original Message-----
From: dans@... [mailto:dans@...]
Sent: Thursday, March 14, 2002 1:37 PM
To: Vantage Group (E-mail)
Subject: [Vantage] Exporting WIP report to Excel
Good morning all,
Â
Is anyone aware of how to export the Production Mgmt/Job Mgmt/Reports/Work
In Process report into Excel?
Â
Bosses request of course and the Vantage people scratched theirs heads and
promise to let me know :-)
Â
Thank you,
Daniel C. Spoerl
Estimator/MIS
Toledo Metal Spinning Co.
Phone: (419) 535-5931 ext. 203
Fax:Â Â Â (419) 535-0565Â
Personal E-fax: (707) 897-1708Â
Email:Â Â Â HYPERLINK
"mailto:dans@..."dans@...
WebSite: HYPERLINK
"http://www.toledometalspinning.com/"http://www.toledometalspinning.com
HYPERLINK "http://www.toledometalspinning.com/products_configurator.htm" \n
Â
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.336 / Virus Database: 188 - Release Date: 3/11/2002
[Non-text portions of this message have been removed]
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 http://docs.yahoo.com/info/terms/
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 http://docs.yahoo.com/info/terms/
Sorry to tell you this, Gary, but somebody from Vantage gave me that one
about 4 years ago. I'm just not fast enough with the e-mail anymore, have
just now read three day's worth.
Lydia
-----Original Message-----
From: Gary Polvinale [mailto:garyp@...]
Sent: Thursday, March 14, 2002 1:16 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Exporting WIP report to Excel
Unbelievable, Chris. Brilliant in its simplicity. It's a great hack!
It'll appear on the Epicor website tomorrow as an undocumented Vantage
feature, I suspect. I love it!
I happened to be needing to get something from Vantage into Excel just as
you sent the message. Thanks. This is one I'll take with me for sure.
...and this year's Vantage "Great Hack" award goes to... Chris Reed.
Gary Polvinale
Denton ATD
-----Original Message-----
From: Chris Reed [mailto:chrisr@...]
Sent: Thursday, March 14, 2002 9:04 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Exporting WIP report to Excel
FYI
I preview the report in Vantage, open the .rpt file it creates in the local
vntgwork directory in XL and edit from there.
HTH Chris Reed
PWSL
-----Original Message-----
From: dans@... [mailto:dans@...]
Sent: Thursday, March 14, 2002 1:37 PM
To: Vantage Group (E-mail)
Subject: [Vantage] Exporting WIP report to Excel
Good morning all,
Is anyone aware of how to export the Production Mgmt/Job Mgmt/Reports/Work
In Process report into Excel?
Bosses request of course and the Vantage people scratched theirs heads and
promise to let me know :-)
Thank you,
Daniel C. Spoerl
Estimator/MIS
Toledo Metal Spinning Co.
Phone: (419) 535-5931 ext. 203
Fax: (419) 535-0565
Personal E-fax: (707) 897-1708
Email: HYPERLINK
"mailto:dans@..."dans@...
WebSite: HYPERLINK
"http://www.toledometalspinning.com/"http://www.toledometalspinning.com
HYPERLINK "http://www.toledometalspinning.com/products_configurator.htm" \n
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.336 / Virus Database: 188 - Release Date: 3/11/2002
[Non-text portions of this message have been removed]
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 http://docs.yahoo.com/info/terms/
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 http://docs.yahoo.com/info/terms/
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 http://docs.yahoo.com/info/terms/
Another way to accomplish this is to create a printer using the Generic Text
Printer driver from Microsoft (All flavors of Windows have this driver
included, it just needs to be installed) and instead of pointing it to LPT1
point it to FILE. Every time you print the driver will ask you where you
want to save the file. As a matter of convenience, make sure you always use
the extension of TXT or PRN, Excel has an option to open those directly.
This approach avoids the timing issues related to getting the reports the
moment that they are printed.
Ted Kitch
ted@...
-----Original Message-----
From: Lydia Coffman [mailto:lcoffman@...]
Sent: Thursday, March 14, 2002 4:40 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Exporting WIP report to Excel
Sorry to tell you this, Gary, but somebody from Vantage gave me that one
about 4 years ago. I'm just not fast enough with the e-mail anymore, have
just now read three day's worth.
Lydia
-----Original Message-----
From: Gary Polvinale [mailto:garyp@...]
Sent: Thursday, March 14, 2002 1:16 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Exporting WIP report to Excel
Unbelievable, Chris. Brilliant in its simplicity. It's a great hack!
It'll appear on the Epicor website tomorrow as an undocumented Vantage
feature, I suspect. I love it!
I happened to be needing to get something from Vantage into Excel just as
you sent the message. Thanks. This is one I'll take with me for sure.
...and this year's Vantage "Great Hack" award goes to... Chris Reed.
Gary Polvinale
Denton ATD
-----Original Message-----
From: Chris Reed [mailto:chrisr@...]
Sent: Thursday, March 14, 2002 9:04 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Exporting WIP report to Excel
FYI
I preview the report in Vantage, open the .rpt file it creates in the local
vntgwork directory in XL and edit from there.
HTH Chris Reed
PWSL
-----Original Message-----
From: dans@... [mailto:dans@...]
Sent: Thursday, March 14, 2002 1:37 PM
To: Vantage Group (E-mail)
Subject: [Vantage] Exporting WIP report to Excel
Good morning all,
Is anyone aware of how to export the Production Mgmt/Job Mgmt/Reports/Work
In Process report into Excel?
Bosses request of course and the Vantage people scratched theirs heads and
promise to let me know :-)
Thank you,
Daniel C. Spoerl
Estimator/MIS
Toledo Metal Spinning Co.
Phone: (419) 535-5931 ext. 203
Fax: (419) 535-0565
Personal E-fax: (707) 897-1708
Email: HYPERLINK
"mailto:dans@..."dans@...
WebSite: HYPERLINK
"http://www.toledometalspinning.com/ <http://www.toledometalspinning.com/>
"http://www.toledometalspinning.com <http://www.toledometalspinning.com>
HYPERLINK "http://www.toledometalspinning.com/products_configurator.htm
<http://www.toledometalspinning.com/products_configurator.htm> " \n
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
<http://www.grisoft.com).>
Version: 6.0.336 / Virus Database: 188 - Release Date: 3/11/2002
[Non-text portions of this message have been removed]
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
<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
<http://groups.yahoo.com/group/vantage/links>
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>
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
<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
<http://groups.yahoo.com/group/vantage/links>
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>
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
<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
<http://groups.yahoo.com/group/vantage/links>
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>
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
<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
<http://groups.yahoo.com/group/vantage/links>
Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.
[Non-text portions of this message have been removed]
-----Original Message-----
From: Ted Kitch [mailto:ted@...]
Sent: Friday, March 15, 2002 12:15 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Exporting WIP report to Excel
Another way to accomplish this is to create a printer using the Generic Text
Printer driver from Microsoft (All flavors of Windows have this driver
included, it just needs to be installed) and instead of pointing it to LPT1
point it to FILE. Every time you print the driver will ask you where you
want to save the file. As a matter of convenience, make sure you always use
the extension of TXT or PRN, Excel has an option to open those directly.
This approach avoids the timing issues related to getting the reports the
moment that they are printed.
Ted Kitch
ted@...
-----Original Message-----
From: Lydia Coffman [mailto:lcoffman@...]
Sent: Thursday, March 14, 2002 4:40 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Exporting WIP report to Excel
Sorry to tell you this, Gary, but somebody from Vantage gave me that one
about 4 years ago. I'm just not fast enough with the e-mail anymore, have
just now read three day's worth.
Lydia
-----Original Message-----
From: Gary Polvinale [mailto:garyp@...]
Sent: Thursday, March 14, 2002 1:16 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Exporting WIP report to Excel
Unbelievable, Chris. Brilliant in its simplicity. It's a great hack!
It'll appear on the Epicor website tomorrow as an undocumented Vantage
feature, I suspect. I love it!
I happened to be needing to get something from Vantage into Excel just as
you sent the message. Thanks. This is one I'll take with me for sure.
...and this year's Vantage "Great Hack" award goes to... Chris Reed.
Gary Polvinale
Denton ATD
-----Original Message-----
From: Chris Reed [mailto:chrisr@...]
Sent: Thursday, March 14, 2002 9:04 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Exporting WIP report to Excel
FYI
I preview the report in Vantage, open the .rpt file it creates in the local
vntgwork directory in XL and edit from there.
HTH Chris Reed
PWSL
-----Original Message-----
From: dans@... [mailto:dans@...]
Sent: Thursday, March 14, 2002 1:37 PM
To: Vantage Group (E-mail)
Subject: [Vantage] Exporting WIP report to Excel
Good morning all,
Is anyone aware of how to export the Production Mgmt/Job Mgmt/Reports/Work
In Process report into Excel?
Bosses request of course and the Vantage people scratched theirs heads and
promise to let me know :-)
Thank you,
Daniel C. Spoerl
Estimator/MIS
Toledo Metal Spinning Co.
Phone: (419) 535-5931 ext. 203
Fax: (419) 535-0565
Personal E-fax: (707) 897-1708
Email: HYPERLINK
"mailto:dans@..."dans@...
WebSite: HYPERLINK
"http://www.toledometalspinning.com/ <http://www.toledometalspinning.com/>
"http://www.toledometalspinning.com <http://www.toledometalspinning.com>
HYPERLINK "http://www.toledometalspinning.com/products_configurator.htm
<http://www.toledometalspinning.com/products_configurator.htm> " \n
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
<http://www.grisoft.com).>
Version: 6.0.336 / Virus Database: 188 - Release Date: 3/11/2002
[Non-text portions of this message have been removed]
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
<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
<http://groups.yahoo.com/group/vantage/links>
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>
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
<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
<http://groups.yahoo.com/group/vantage/links>
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>
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
<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
<http://groups.yahoo.com/group/vantage/links>
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>
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
<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
<http://groups.yahoo.com/group/vantage/links>
Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.
[Non-text portions of this message have been removed]
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 http://docs.yahoo.com/info/terms/
I think I read once (in this list) that some folks consider the
generic text printer 'quirky'.
Usually it works so nicely, but then we have a couple users that send
report builder reports to generic text, open excel and see only a
square box.
These same reports can be run from other PCs with no problems.
I also have a user who can run some (but not all) report builder
reports to generic text successfully.
Has anyone else had this problem?
Thanks, Jill
--- In vantage@y..., "Gary Polvinale" <garyp@d...> wrote:
> I'm going to use this one. Thanks, Ted. -Gary
>
> -----Original Message-----
> From: Ted Kitch [mailto:ted@m...]
> Sent: Friday, March 15, 2002 12:15 AM
> To: 'vantage@y...'
> Subject: RE: [Vantage] Exporting WIP report to Excel
>
>
> Another way to accomplish this is to create a printer using the
Generic Text
> Printer driver from Microsoft (All flavors of Windows have this
driver
> included, it just needs to be installed) and instead of pointing it
to LPT1
> point it to FILE. Every time you print the driver will ask you
where you
> want to save the file. As a matter of convenience, make sure you
always use
> the extension of TXT or PRN, Excel has an option to open those
directly.
> This approach avoids the timing issues related to getting the
reports the
> moment that they are printed.
>
> Ted Kitch
> ted@m...
>
> -----Original Message-----
> From: Lydia Coffman [mailto:lcoffman@c...]
> Sent: Thursday, March 14, 2002 4:40 PM
> To: vantage@y...
> Subject: RE: [Vantage] Exporting WIP report to Excel
>
> Sorry to tell you this, Gary, but somebody from Vantage gave me
that one
> about 4 years ago. I'm just not fast enough with the e-mail
anymore, have
> just now read three day's worth.
>
> Lydia
>
>
> -----Original Message-----
> From: Gary Polvinale [mailto:garyp@d...]
> Sent: Thursday, March 14, 2002 1:16 PM
> To: vantage@y...
> Subject: RE: [Vantage] Exporting WIP report to Excel
>
> Unbelievable, Chris. Brilliant in its simplicity. It's a great
hack!
> It'll appear on the Epicor website tomorrow as an undocumented
Vantage
> feature, I suspect. I love it!
>
> I happened to be needing to get something from Vantage into Excel
just as
> you sent the message. Thanks. This is one I'll take with me for
sure.
> ...and this year's Vantage "Great Hack" award goes to... Chris Reed.
>
> Gary Polvinale
> Denton ATD
>
> -----Original Message-----
> From: Chris Reed [mailto:chrisr@p...]
> Sent: Thursday, March 14, 2002 9:04 AM
> To: vantage@y...
> Subject: RE: [Vantage] Exporting WIP report to Excel
>
>
> FYI
>
> I preview the report in Vantage, open the .rpt file it creates in
the local
> vntgwork directory in XL and edit from there.
>
> HTH Chris Reed
> PWSL
>
> -----Original Message-----
> From: dans@t... [mailto:dans@t...]
> Sent: Thursday, March 14, 2002 1:37 PM
> To: Vantage Group (E-mail)
> Subject: [Vantage] Exporting WIP report to Excel
>
>
> Good morning all,
>
> Is anyone aware of how to export the Production Mgmt/Job
Mgmt/Reports/Work
> In Process report into Excel?
>
> Bosses request of course and the Vantage people scratched theirs
heads and
> promise to let me know :-)
>
> Thank you,
>
> Daniel C. Spoerl
> Estimator/MIS
> Toledo Metal Spinning Co.
> Phone: (419) 535-5931 ext. 203
> Fax: (419) 535-0565
> Personal E-fax: (707) 897-1708
> Email: HYPERLINK
> "mailto:dans@t..."dans@t...
> WebSite: HYPERLINK
> "http://www.toledometalspinning.com/
<http://www.toledometalspinning.com/>
> "http://www.toledometalspinning.com
<http://www.toledometalspinning.com>
>
HYPERLINK "http://www.toledometalspinning.com/products_configurator.ht
m
> <http://www.toledometalspinning.com/products_configurator.htm> " \n
>
>
>
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> <http://www.grisoft.com).>
> Version: 6.0.336 / Virus Database: 188 - Release Date: 3/11/2002
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> 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
> <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
> <http://groups.yahoo.com/group/vantage/links>
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> <http://docs.yahoo.com/info/terms/>
>
>
>
>
>
>
> 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
> <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
> <http://groups.yahoo.com/group/vantage/links>
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> <http://docs.yahoo.com/info/terms/>
>
>
>
>
>
> 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
> <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
> <http://groups.yahoo.com/group/vantage/links>
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> <http://docs.yahoo.com/info/terms/>
>
>
>
>
>
> Yahoo! Groups Sponsor
>
>
> ADVERTISEMENT
>
>
<http://rd.yahoo.com/M=215002.1818248.3328688.1261774/D=egroupweb/S=17
050071
> 83:HM/A=847665/R=0/*http:/ads.x10.com/?
bHlhaG9vbW9uc3RlcjcuZGF0=1016145576%3
>
eM=215002.1818248.3328688.1261774/D=egroupweb/S=1705007183:HM/A=847665
/R=1>
>
>
> <http://us.adserver.yahoo.com/l?
M=215002.1818248.3328688.1261774/D=egroupmai
> l/S=1705007183:HM/A=847665/rand=696080785>
>
> 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
> <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
> <http://groups.yahoo.com/group/vantage/links>
>
> Your use of Yahoo! Groups is subject to the Yahoo!
> <http://docs.yahoo.com/info/terms/> Terms of Service.
>
>
> [Non-text portions of this message have been removed]
>
>
>
> 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
http://docs.yahoo.com/info/terms/
yup, with the bom report. I found that if you hit print preview, it creates
a temporary file in the vntgwrk directory. Sort by 'Modified' and the text
file (RPT[random number].txt) should show up on top (or bottom) as it is the
most recent.
This file could be imported into excel, using fixed width. I understand
there is a program called MONARCH that automates this process further.
I eventually gave up and wrote my own indented BOM in progress, with the
help of Lonnie and others.
Thaddeus
-----Original Message-----
From: jlpleau [mailto:jpleau@...]
Sent: Friday, March 15, 2002 9:25 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Exporting WIP report to Excel
I think I read once (in this list) that some folks consider the
generic text printer 'quirky'.
Usually it works so nicely, but then we have a couple users that send
report builder reports to generic text, open excel and see only a
square box.
These same reports can be run from other PCs with no problems.
I also have a user who can run some (but not all) report builder
reports to generic text successfully.
Has anyone else had this problem?
Thanks, Jill
--- In vantage@y..., "Gary Polvinale" <garyp@d...> wrote:
> I'm going to use this one. Thanks, Ted. -Gary
>
> -----Original Message-----
> From: Ted Kitch [mailto:ted@m...]
> Sent: Friday, March 15, 2002 12:15 AM
> To: 'vantage@y...'
> Subject: RE: [Vantage] Exporting WIP report to Excel
>
>
> Another way to accomplish this is to create a printer using the
Generic Text
> Printer driver from Microsoft (All flavors of Windows have this
driver
> included, it just needs to be installed) and instead of pointing it
to LPT1
> point it to FILE. Every time you print the driver will ask you
where you
> want to save the file. As a matter of convenience, make sure you
always use
> the extension of TXT or PRN, Excel has an option to open those
directly.
> This approach avoids the timing issues related to getting the
reports the
> moment that they are printed.
>
> Ted Kitch
> ted@m...
>
> -----Original Message-----
> From: Lydia Coffman [mailto:lcoffman@c...]
> Sent: Thursday, March 14, 2002 4:40 PM
> To: vantage@y...
> Subject: RE: [Vantage] Exporting WIP report to Excel
>
> Sorry to tell you this, Gary, but somebody from Vantage gave me
that one
> about 4 years ago. I'm just not fast enough with the e-mail
anymore, have
> just now read three day's worth.
>
> Lydia
>
>
> -----Original Message-----
> From: Gary Polvinale [mailto:garyp@d...]
> Sent: Thursday, March 14, 2002 1:16 PM
> To: vantage@y...
> Subject: RE: [Vantage] Exporting WIP report to Excel
>
> Unbelievable, Chris. Brilliant in its simplicity. It's a great
hack!
> It'll appear on the Epicor website tomorrow as an undocumented
Vantage
> feature, I suspect. I love it!
>
> I happened to be needing to get something from Vantage into Excel
just as
> you sent the message. Thanks. This is one I'll take with me for
sure.
> ...and this year's Vantage "Great Hack" award goes to... Chris Reed.
>
> Gary Polvinale
> Denton ATD
>
> -----Original Message-----
> From: Chris Reed [mailto:chrisr@p...]
> Sent: Thursday, March 14, 2002 9:04 AM
> To: vantage@y...
> Subject: RE: [Vantage] Exporting WIP report to Excel
>
>
> FYI
>
> I preview the report in Vantage, open the .rpt file it creates in
the local
> vntgwork directory in XL and edit from there.
>
> HTH Chris Reed
> PWSL
>
> -----Original Message-----
> From: dans@t... [mailto:dans@t...]
> Sent: Thursday, March 14, 2002 1:37 PM
> To: Vantage Group (E-mail)
> Subject: [Vantage] Exporting WIP report to Excel
>
>
> Good morning all,
>
> Is anyone aware of how to export the Production Mgmt/Job
Mgmt/Reports/Work
> In Process report into Excel?
>
> Bosses request of course and the Vantage people scratched theirs
heads and
> promise to let me know :-)
>
> Thank you,
>
> Daniel C. Spoerl
> Estimator/MIS
> Toledo Metal Spinning Co.
> Phone: (419) 535-5931 ext. 203
> Fax: (419) 535-0565
> Personal E-fax: (707) 897-1708
> Email: HYPERLINK
> "mailto:dans@t..."dans@t...
> WebSite: HYPERLINK
> "http://www.toledometalspinning.com/
<http://www.toledometalspinning.com/>
> "http://www.toledometalspinning.com
<http://www.toledometalspinning.com>
>
HYPERLINK "http://www.toledometalspinning.com/products_configurator.ht
m
> <http://www.toledometalspinning.com/products_configurator.htm> " \n
>
>
>
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> <http://www.grisoft.com).>
> Version: 6.0.336 / Virus Database: 188 - Release Date: 3/11/2002
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> 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
> <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
> <http://groups.yahoo.com/group/vantage/links>
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> <http://docs.yahoo.com/info/terms/>
>
>
>
>
>
>
> 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
> <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
> <http://groups.yahoo.com/group/vantage/links>
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> <http://docs.yahoo.com/info/terms/>
>
>
>
>
>
> 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
> <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
> <http://groups.yahoo.com/group/vantage/links>
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> <http://docs.yahoo.com/info/terms/>
>
>
>
>
>
> Yahoo! Groups Sponsor
>
>
> ADVERTISEMENT
>
>
<http://rd.yahoo.com/M=215002.1818248.3328688.1261774/D=egroupweb/S=17
050071
> 83:HM/A=847665/R=0/*http:/ads.x10.com/?
bHlhaG9vbW9uc3RlcjcuZGF0=1016145576%3
>
eM=215002.1818248.3328688.1261774/D=egroupweb/S=1705007183:HM/A=847665
/R=1>
>
>
> <http://us.adserver.yahoo.com/l?
M=215002.1818248.3328688.1261774/D=egroupmai
> l/S=1705007183:HM/A=847665/rand=696080785>
>
> 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
> <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
> <http://groups.yahoo.com/group/vantage/links>
>
> Your use of Yahoo! Groups is subject to the Yahoo!
> <http://docs.yahoo.com/info/terms/> Terms of Service.
>
>
> [Non-text portions of this message have been removed]
>
>
>
> 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
http://docs.yahoo.com/info/terms/
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 http://docs.yahoo.com/info/terms/