Re: Crystal Reports using AS/400 data

Well, let's split hairs. It's all IFS. IFS stands for Integrated File
System. This also includes /qsys.lib, /qopt for all your optical drives,
/qntc for shares on other PC's and servers and more. But most people are
thinking "stream file system" when they say IFS. Tables and logicals are
not stream files. Yes you can do
WRKLNK '/QSYS.LIB/MYLIB.LIB/MYFILE.FILE/*.MBR' and get a list of members
in a file (or partitions in a table if you like to talk database). And I
can even do this
EDTF '/QSYS.LIB/ERPLXF.LIB/RCO.FILE/RCO.MBR'
which kind of frightens the hell out of me.
But still, people generally consider tables and logicals part of the
/qsys.lib file system and not part of the stream file system. And those
who feel their beliefs are absolute do not consider that part of the IFS.

ps:
I find
WRKLNK '/QSYS.LIB/MYLIB.LIB/MYFILE.FILE/*.MBR'
extremely useful on systems without PDM. Most of my lpars do not have PDM
even though the box may be licensed for it. Does a great job of
discouraging development on production lpars.

Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Hoteltravelfundotcom <hoteltravelfun@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>,
Date: 04/24/2013 08:27 AM
Subject: Re: Crystal Reports using AS/400 data
Sent by: midrange-l-bounces@xxxxxxxxxxxx



So in fact, do you use the IFS when you are making the connection from
Crystal. When you say ODBC connection to AS/400 tables or logicals, this
is
actually using the IFS?


On Mon, Apr 22, 2013 at 10:41 AM, Richard Schoen
<richard@xxxxxxxxxxxxxxx>wrote:

Not sure if they have added ability to run form a command line in recent
releases, but we had written some wrappers to call Crystal and process
documents with Crystal for previous projects.

This allowed us to then call out desired reports on the fly.

With that in place you don't really need Crystal Enterprise.

Regards,
Richard Schoen
RJS Software Systems Inc.
Where Information Meets Innovation
Document Management, Workflow, Report Delivery, Forms and Business
Intelligence
Email: richard@xxxxxxxxxxxxxxx
Web Site: http://www.rjssoftware.com
Tel: (952) 736-5800
Fax: (952) 736-5801
Toll Free: (888) RJSSOFT
------------------------------

message: 3
date: Mon, 22 Apr 2013 09:20:28 -0400
from: Hoteltravelfundotcom <hoteltravelfun@xxxxxxxxx>
subject: Re: Crystal Reports using AS/400 data

Rich, that's what I was thinking. Why use the CR formulas which are

often

a bit convoluted.
Didn't know it can read an XML file i have to check that. Other

question

i have is how to use the Crystal Enterprise but this is probably the

wrong

forum.
For instance, suppose you want to run Report B based on a result in

REport

A for certain users, else run Report C.

on the AS/400, there are many ways but you could just do this in a CL.


On Mon, Apr 22, 2013 at 9:12 AM, Richard Schoen <richard@xxxxxxxxxxxxxxx

wrote:

If you're using Crystal, make sure to consider simply generating XML
files for input and then the reports are for presentation only.
Simplifies the process.

If you're looking for IBM i based alternatives our iForms product can
be used to natively generates reports and electronic forms in a
variety of formats including print, PDF, HTML, RTC, CSV and more.

CL commands can also be embedded in your application code as needed.

Regards,
Richard Schoen
RJS Software Systems Inc.
Where Information Meets Innovation
Document Management, Workflow, Report Delivery, Forms and Business
Intelligence
Email: richard@xxxxxxxxxxxxxxx
Web Site: http://www.rjssoftware.com
Tel: (952) 736-5800
Fax: (952) 736-5801
Toll Free: (888) RJSSOFT

--
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.

--
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.


--
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.