Sales Analysis Report to Excel

Yahoo Archive
1
We would really like to sort our WIP report by dollar value descending.
Due to the layout of the report, I cannot seem to get the Excel method
of grabbing the data to work.



Any Suggestions?


Thanks,



Bruce Butler

IT Manager

Knappe & Koester, Inc.

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian Stenglein
Sent: Tuesday, November 22, 2005 1:48 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Sales Analysis Report to Excel



Instead of cutting and pasting, try opening the text file with Excel.
If you're going to do the same things frequently you may want to look
into setting up a macro in Excel to automate it.

I've done some things here for our controller so that he previews an
report in Vantage, opens Excel and runs a macro, and his data is pulled
in, reformatted and printed from Excel.

HTH,

Brian Stenglein
Clow Stamping Co.


--- In vantage@yahoogroups.com, "mxi_m" <mikhail_m@h...> wrote:
>
> How to export Sales Analysis or any other Vantage 8.0 report to Excel?
>
> So far I found, that after you preview report it create a Text file
of
> that report.
> But copy and paste that information to excel makes it very long and
> difficult way for formatting and work with that information in excel.
>
> Any suggestions?
>
> Thanks.
>



_____



[Non-text portions of this message have been removed]
2
How to export Sales Analysis or any other Vantage 8.0 report to Excel?

So far I found, that after you preview report it create a Text file of
that report.
But copy and paste that information to excel makes it very long and
difficult way for formatting and work with that information in excel.

Any suggestions?

Thanks.
3
I use cut & paste, however, You can build a query under system
management - business management query. This can be down loaded straight
to excel, just be careful with the table links.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of mxi_m
Sent: Tuesday, November 22, 2005 11:11 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Sales Analysis Report to Excel

How to export Sales Analysis or any other Vantage 8.0 report to Excel?

So far I found, that after you preview report it create a Text file of
that report.
But copy and paste that information to excel makes it very long and
difficult way for formatting and work with that information in excel.

Any suggestions?

Thanks.






------------------------ Yahoo! Groups Sponsor --------------------~-->
Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home
page http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/PhFolB/TM
--------------------------------------------------------------------~->

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
Yahoo! Groups Links
4
Instead of cutting and pasting, try opening the text file with Excel.
If you're going to do the same things frequently you may want to look
into setting up a macro in Excel to automate it.

I've done some things here for our controller so that he previews an
report in Vantage, opens Excel and runs a macro, and his data is pulled
in, reformatted and printed from Excel.

HTH,

Brian Stenglein
Clow Stamping Co.


--- In vantage@yahoogroups.com, "mxi_m" <mikhail_m@h...> wrote:
>
> How to export Sales Analysis or any other Vantage 8.0 report to Excel?
>
> So far I found, that after you preview report it create a Text file
of
> that report.
> But copy and paste that information to excel makes it very long and
> difficult way for formatting and work with that information in excel.
>
> Any suggestions?
>
> Thanks.
>