Reporting Tool

Chris deOrla · Aug 1, 2002

Help !

I'm looking for a tool that will take a JDE or AS400 report and allow the
user to strip out all the headings, descriptive text , page numbering, etc.
and place it into a spreadsheet or document format so that they can massage
the numbers or do whatever calcs they like on the resulting data. I know
that eons ago, there used to be such a tool, but the company and/or
software name escapes me...anyone got any ideas ?

Thanks,

Cd

Chris de Orla
Consultant
World Software V7.3.12 AS400 V4R4

brian · Aug 1, 2002

I think you're looking for ODBCFace.

http://www.odbcface.com

----- Original Message -----
From: "Chris_deOrla" <[email protected]>
To: <[email protected]>
Sent: Thursday, August 01, 2002 6:51 PM
Subject: Reporting Tool

etc.
massage

elway · Aug 2, 2002

Chris,

using "native" JDE/400 tools it is possible to generate a physical file from DW, WW or Query and a CSV from FASTR. The extra effort needed is stripping out or reformatting the data once imported into the spreadsheet but the base functionality is available free, as it were.

HTH.

Aharrison · Aug 2, 2002

Symtrax's Compleo will do this.

http://www.symtrax.com

Andrew Harrison
MIS Project Manager
VPI, LLC
1389 School House Road
Delaware City, DE 19706
Tel: (302) 836-7539
Fax: (302) 836-7622
mailto:[email protected]
Web Page: HTTP://WWW.VPICORP.COM

(Running JDE World A8.1 cum 1)

Chris deOrla · Aug 2, 2002

We're doing it this way today. Problem is our Excel users are both
impatient and inexperienced when it comes to parsing out the reports,
especially 200 page reports (tedious at best). For smaller reports, this
works fine, and for Query and FASTR reports its not a problem (as we do
produce output-to-file reports)... This involves particularly DW and
custom-written reports that would be too complicated to re-write to produce
an output-to-file for Excel.

Thanks..

Cd

elway
<elwaycon@hotmai To: [email protected]
l.com> cc:
Sent by: Subject: Re: Reporting Tool
owner-jdeworld@j
delist.com

02-08-02 02:51
Please respond
to jdeworld

Chris,

using "native" JDE/400 tools it is possible to generate a physical file
from DW, WW or Query and a CSV from FASTR. The extra effort needed is
stripping out or reformatting the data once imported into the spreadsheet
but the base functionality is available free, as it were.

HTH.
--------------------------
To view this thread, go to:
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=W&Number=39076
+ - - - - - - - - - - - - - - - - - - - - - - - -+
This is the JDEList World? mailing list/forum.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found on the JDEList Forum at
http://www.JDEList.com

JDEList is not affiliated with JDEdwards®

+ - - - - - - - - - - - - - - - - - - - - - - - -+

Chris de Orla
Consultant
World Software V7.3.12 AS400 V4R4

Michael_Donathan · Aug 2, 2002

Chris
We use a product called Compleo by Symtrax.(www.symtrax.com)

Michael Donathan CPIM
Sr. Programmer Analyst
White-Rodgers Division of Emerson
(314) 865-8753
[email protected]

jean_driscoll · Aug 2, 2002

At my previous employment users used Paradox (PC database tool) in association with another product Printq that brought the spool file down to the pc as a text file.

tgore · Aug 2, 2002

We use this function of WW, DW and FASTR. We use RUMBA as our terminal emulator. RUMBA has a nice file transfer utility. That is how we convert our files to spreadsheets. Client Access also has a file transfer utility, but we haven't used it. You might even be able to FTP the AS400 file down to a PC.

KENNEY · Aug 2, 2002

As others have stated , you can get a CSV file from FASTR , and I believe
you can suppress the printing of headings. There is a product called
Monarch for EZ-Pickins from BCD software , I have never tried it , so I
can't vouch for its functionallity or quality, they state in their ad that
you can get a free trial @ www.bcdsoftware.com .

Michael Kenney
IT Services
University of Windsor

etc.
massage
--------------------------

Mike_Ryan · Aug 2, 2002

Hi Chris,

We are on JDE 7.3.12 and have been using Compleo from Symtrax. Just run =
the
report and then bring it up in Compleo and you can keep the headings or
delete them. Keep the blank lines. Only bring down certain columns of a
report. You can do multiple reports is one pass of Compleo. Just pick =
up
total lines off a report. Here is there website.
http://www.mysymtrax.com/

Mike Ryan
White-Rodgers Div. of Emerson=20
Email [email protected]=20
Voice 314-865-8645=20
Fax 314-865-8764=20

Krusador · Aug 2, 2002

You might want to take a look at a product named Monarch - it will allow you to define templates around a report so that you only extract the data you need and then will convert that into spreadsheet format. It's been a few years since I've used it, so I'm not even sure if they're still around or what their web address is.

Krusador · Aug 2, 2002

I found their web address: http://www.hallogram.com/monarch/

I found it somewhat cumbersome to use, but the results were exactly what we needed.

Chris deOrla · Aug 2, 2002

BINGO ! Thats exactly the one I was looking for...and they are still
around at http://www.datawatch.com/products/v6_pro.htm

Thanks for your help !

Cd

Krusador
<Bob.Cagle@LynkI To: [email protected]
nc.com> cc:
Sent by: Subject: Re: Reporting Tool
owner-jdeworld@j
delist.com

02-08-02 07:27
Please respond
to jdeworld

You might want to take a look at a product named Monarch - it will allow
you to define templates around a report so that you only extract the data
you need and then will convert that into spreadsheet format. It's been a
few years since I've used it, so I'm not even sure if they're still around
or what their web address is.
Bob Cagle
IT Manager
Lynk, Inc.
A8.1c3
--------------------------
To view this thread, go to:
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=W&Number=39099
+ - - - - - - - - - - - - - - - - - - - - - - - -+
This is the JDEList World? mailing list/forum.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found on the JDEList Forum at
http://www.JDEList.com

JDEList is not affiliated with JDEdwards®

+ - - - - - - - - - - - - - - - - - - - - - - - -+

Chris de Orla
Consultant
World Software V7.3.12 AS400 V4R4

dale_draper · Aug 2, 2002

Also, you may want to take a look at S4I express, a very powerful report
distribution tool with a LOT of capabilities built in www.solution400.com we
are nearing the completion of our testing and are about ready to purchase.
They also have a JDE OW specific components for distributing OW PDF's.

a7.3c9

BillFClark · Aug 2, 2002

I know a tool we used several years back was called Monarch. It would take an AS400 spool file and let you strip and parse the data. I do not know if it is still around though. We use Showcase here to for our reporting.

tboat00 · Aug 5, 2002

I have had very much success with a product called Monarch. It strips data from text based report files and creates spreadsheet ready files in many formats.

tgore · Apr 16, 2003

Re: RE: Reporting Tool

Can anybody give me an idea of the cost of Compleo? It sounds like a real good tool.

Thanks

justcause · Apr 24, 2003

Not - sure - but I have heard the name "Easy Pickens"

Greenm · Apr 24, 2003

We have been using EZ-Pickin's & Spool Explorer for several years. Despite
it's funny name the program works very well. Contact BCD at
www.BCDsoftware.com or
630.9986.0800 for a free trial.

Reporting Tool

Chris deOrla

Member

brian

Member

elway

Active Member

Aharrison

Member

Chris deOrla

Member

Michael_Donathan

Member

jean_driscoll

VIP Member

tgore

Reputable Poster

KENNEY

Well Known Member

Mike_Ryan

Member

Krusador

Active Member

Krusador

Active Member

Chris deOrla

Member

dale_draper

Well Known Member

BillFClark

Active Member

tboat00

Well Known Member

tgore

Reputable Poster

justcause

Member

Greenm

Member

Similar threads

We value your privacy