Exporting Standard Reports to Excel

I just got this from Vantage Today:



Summary: XA How can I print a report from Vantage or Vista to a file?

Book: Support Solutions

Page: 707MPS

707MPS

QUESTION:

How can I print a report from Vantage or Vista to a file?

ANSWER:

You can add a Generic printer to your printer folder as follows:

1. Go to My Computer\Printers and select Add Printer.

2. Select local printer and Generic.

3. Select FILE: as your printer port.

When the printer has been added, it will be available in your drop down list of printers when you print the report. Select the Generic printer. The report will run, and then it will give you an option of which file you want it to go to. Choose a folder to print to (or create a new folder if you prefer). The report will print as a .prn text file which can be opened in Note Pad or Word Pad. You can then copy and paste it into Excel, Word, or other similar file, or you can open the file and Save as... and use a .xls extension or .doc extension to save it as another format.






























-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Scott Jeffers
Sent: Thursday, September 22, 2005 1:51 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Exporting Standard Reports to Excel


Does anyone have any information on how I might be able to run a standard Vantage report and "print" it to a file? In the past we have always tried to recreate the report in either report builder or crystal, but I have to believe there is a way of short-cutting this. Thanks.

Scott

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

[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








[Non-text portions of this message have been removed]
Does anyone have any information on how I might be able to run a standard Vantage report and "print" it to a file? In the past we have always tried to recreate the report in either report builder or crystal, but I have to believe there is a way of short-cutting this. Thanks.

Scott

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

[Non-text portions of this message have been removed]
Scott
Print preview your report. Go to your Epicor work folder. Open the
new .txt file and you have your report in a file. Do a Save As to
somewhere else. Close the Preview.

Cliff

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Scott Jeffers
Sent: Thursday, September 22, 2005 11:51 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Exporting Standard Reports to Excel


Does anyone have any information on how I might be able to run a
standard Vantage report and "print" it to a file? In the past we have
always tried to recreate the report in either report builder or crystal,
but I have to believe there is a way of short-cutting this. Thanks.

Scott

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

[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




SPONSORED LINKS
Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Online+d
atabase+software&c=6&s=185&.sig=AvWEwtBBb2CCZUYeLzjLVQ>
Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=On
line+database+software&c=6&s=185&.sig=8uEu2piLZhrmuaS0aRTs5A> Database
mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Onli
ne+database+software&c=6&s=185&.sig=WxJOMUVfawa-Spj4srksIw>
Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Online+da
tabase+software&c=6&s=185&.sig=8c6UocdSpoECWlSALplOdQ> Database
management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=On
line+database+software&c=6&s=185&.sig=C2nNY1SnmwAiBO61ww9nTw> Online
database software
<http://groups.yahoo.com/gads?t=ms&k=Online+database+software&w1=Manufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+sof
tware&w4=Pda+database+software&w5=Database+management+software&w6=Online
+database+software&c=6&s=185&.sig=cYursVrba9nF7BBMh8EfUA>

________________________________

YAHOO! GROUPS LINKS



* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* 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
Service <http://docs.yahoo.com/info/terms/> .


________________________________




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