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

Hi,
If your not interested in commercial options you can ignore.
We offer a product called iEXL. It will produce fully formatted business level spreadsheets all based and stored on you AS400/Power system.
Options include.

- Fonts
- Colors
- Background and Text
- Text rotation
- Text underline
- Text alignment both horizontal and vertical
- Edit codes
- Column headings
- Functions/Formula
- Merge cells
- Hide columns
- Sort functionality
- Password
- Images
- Freeze Pane
- Page Heading & Footers
- Text insertion
- 50 DB files per workbook
- UNICODE data processing
- Data triggers
- Borders and Grids for document design
- Emails and much more.
- Select and sort required fields from your DB file.
- Insert blank rows before and after a specified row within the spreadsheet.

Please let me know if you have any interest in a product such as iEXL.

Regards,
Mark Golden


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.