RE: Odd request to use reports can this be done.

If it's a one-off, maybe just load up the spool file in Excel and parse it up.

That might work as well.

Regards,

Richard Schoen | Director of Document Management Technologies, HelpSystems
T: + 1 952-486-6802
RJS Software Systems | A Division of HelpSystems
richard.schoen@xxxxxxxxxxxxxxx
www.rjssoftware.com
Visit me on: Twitter | LinkedIn

------------------------------

message: 5
date: Thu, 4 Feb 2016 14:16:57 -0500
from: Hoteltravelfundotcom <hoteltravelfun@xxxxxxxxx>
subject: Re: Odd request to use reports can this be done.

Thanks I'll pass these along. the thing is, this seems to be a one time
need.

On Thu, Feb 4, 2016 at 1:51 PM, MARK GOLDEN <mark_golden@xxxxxxxxxxxxxxx>
wrote:

On Thursday, 4 February 2016, 18:38, Richard Schoen <
Richard.Schoen@xxxxxxxxxxxxxxx> wrote:


Not sure if you're open to commercial options, but we have a product
called DataImport that can be used to convert any report into a
spreadsheet, CSV, or MS Access database which could then be joined into a
Crystal Report.

We also have a Windows business component called AutoMate that can be
used to script the entire process from spool file extraction to running the
Crystal reports.

If you're interested in discussing requirements, feel free to reach out to
me directly or visit our web site for more info.

Regards,

Richard Schoen | Director of Document Management Technologies, HelpSystems
T: + 1 952-486-6802
RJS Software Systems | A Division of HelpSystems
richard.schoen@xxxxxxxxxxxxxxx
www.rjssoftware.com
Visit me on: Twitter | LinkedIn

Join us at ShiftIT, our 2016 user conference (June 20-23) >

-----------------------------------------

From: Hoteltravelfundotcom <hoteltravelfun@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 02/04/2016 09:41 AM
Subject: Odd request to use reports can this be done.
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



HI I have a project that is unfolding where they want to take data from
various sources both on Ibm and other apps in SQL server and meld into one
report in Crystal reports.

The Query/400 are fine but they also want to use reports generated on the
ERP on the 400.

I recall there used to be a way to convert a report to a file, this
strikes
me as a good choice but was also wondering if there are other ways. I seem
to recall this convert to file was sometimes hit or miss. Perhaps someone
still uses this method or has a better idea.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.