We created some raw data Crystal Reports, so users can run and export the data from the report.
Tim
Tim
--- In vantage@yahoogroups.com, "RICH WAGNER" <rwagner@...> wrote:
>
> I'm doing something similar. I have script written in VBS that use the ODBC to exact the data and then write it to an excel file. Some of them the users run themselves with a few input boxes to filter the data and others I hardcode the filters into the script and run them at night via windows task manager and the script also email the user and sometime the customer the file so they have them in the morning.
>
> Thanks,
>
> Rich Wagner
> [cid:image003.jpg@...]
> 2148 Century Drive
> Jefferson Hills, PA 15025
> Phone: (412) 384-3100 x9833
> Fax: (412) 384-2033
> www.bawplastics.com<http://www.bawplastics.com/>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Podlin, Michael
> Sent: Thursday, September 27, 2012 9:34 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Excel reports
>
>
>
> I write Progress procedures to extract data to a txt file which I then
> feed into my AutoRpts program Excel module which opens Excel on the
> server, creates a file, populates and formats the cells according to the
> data txt file, then the file can be saved, printed or e-mailed. Most of
> these run in the middle of the night and the files are ready for people
> when they come in the next morning. I've also have procedures available
> from VBForm buttons so people can generate an excel file report anytime
> at their desk if they need it.
>
> 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@...<mailto:Michael.Podlin%40v-s.com>
>
> Please consider the environment.
> Do you really need to print this email?
> ________________________________
>
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
> Of Tom Jankowski
> Sent: Thursday, September 27, 2012 8:23 AM
> To: Vantage Group
> Subject: [Vantage] Excel reports
>
> Besides XL Connect, is anyone using another package such as Jet Reports
> to write reports in Excel that are linked to your Epicor database?
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
>
> [Non-text portions of this message have been removed]
>