RE: Client Access & AS/400

Otherwise you could output standard prints from the AS400 but send them to a
remote location to be processes by PC printing & formatting software such as
Formscape.

This allows you to output from the AS400, pick up the spooled file on the
PC, process it using whatever logic is needed, format the pint using
graphics etc then output the re-formatted print to printers, fax or e-mail.
Depends whether you need the data itself or just a reformatted print.

Cheers,

Jenny

-----Original Message-----
From: MWalter@hanoverwire.com [mailto:MWalter@hanoverwire.com]
Sent: 30 May 2002 13:12
To: rpg400-l@midrange.com
Subject: Re: Client Access & AS/400



George,

I would use the Client Access ODBC driver and use a tool like Crystal
Reports for your presentation. That way, your data is timely. If you must
use Access, set up an link using your ODBC connection to the 400. Then use
Access for your presentation.


Thanks,

Mark


Mark Walter
Sr. Programmer/Analyst
Hanover Wire Cloth a div of CCX, Inc.
mwalter@hanoverwire.com
http://www.hanoverwire.com
717.637.3795 Ext.3040



                    "George Titus"
                    <georgety2k@hotma        To:     rpg400-l@midrange.com
                    il.com>                  cc:
                    Sent by:                 Subject:     Client Access &
AS/400
                    rpg400-l-admin@mi
                    drange.com


                    05/30/02 01:06 AM
                    Please respond to
                    rpg400-l






Hi,

I am developing an application on as/400 by using RPG but need to develop
user reports on client because of colorful presentation and most of the
reports forms are preprinted. Our database will be reside on as/400 but
need
to access required files and selected data from client. Data to be saved on
client in MS Access and then reports would be generated and printed from
client. I want records selection criteria for selecting user requested data
from client.

I have no idea how to do it, what tools, software and technical expertise
is
needed. Any advice and idea would be appreciated.

Regard.


_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.





_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.