For Progress text files, I have been using an Excel add-in called Import Wizard by Beside. www.beside.com. It allows you to mark headers to ignore, and records and fields to import.
Rob
Rob
--- In vantage@yahoogroups.com, Karen Schoenung <kschoenung@...> wrote:
>
> The WIP in 8.03 is a progress report from what I remember and outputs a text file - which CAN be opened in Excel using the text import option, but then needs all kinds of clean up. Otherwise, you need a custom version written by a consultant. Codabears did a version for us (8.03.409C SQL) using SSRS.
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Mike Abell
> Sent: Thursday, December 26, 2013 1:04 PM
> To: <vantage@yahoogroups.com>
> Cc: vantage@yahoogroups.com
> Subject: Re: [Vantage] RE: Vantage 8.03 WIP report to Excel
>
> I would LOVE to do that but how is that possible from within Vantage 8.03? If this is possible, you seriously made my day.
>
> Sent from Mike's Iphone5
>
> On Dec 26, 2013, at 1:01 PM, "Anthony Gercar" <agercar@...<mailto:agercar@...>> wrote:
>
>
> Save the report as a crystal report. Then do the export from within crystal.
>
> From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com] On Behalf Of Mike Abell
> Sent: Thursday, December 26, 2013 1:55 PM
> To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
> Subject: [Vantage] Vantage 8.03 WIP report to Excel
>
>
>
> Anyone know of ANY way to export the Vantage WIP report to Excel?
>
> Sent from Mike's Iphone5
>
>
>
>
> ------------------------------------
>
> 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/linksYahoo Groups Links
>