RE: Crystal Reports using AS/400 data

["Paul Nelson" <nelsonp@xxxxxxxxxxxxx>]

You should have spent the money for SEQUEL. Their GUI product Viewpoint uses
CR under the covers. 

You can have it installed and running in about 10 minutes. I have clients
who got Business Objects for free from their application software vendor,
and use SEQUEL instead.

Now that BO is owned by Oracle, that vendor (a competitor of JD Edwards) is
trying to get their customers to switch to Cognos.

Pass the popcorn.

Paul Nelson
Cell 708-670-6978
Office 512-392-2577
nelsonp@xxxxxxxxxxxxx

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Steve Richter
Sent: Monday, April 22, 2013 7:41 AM
To: Midrange Systems Technical Discussion
Subject: Re: Crystal Reports using AS/400 data

you have to beware. When I used crystal reports about 4  years ago we
pretty much had to buy tech support for $2500. There were just too many
technical questions we needed answered to use the product correctly.  And
then there was $2500 for the support of the business objects component of
the product. No way I could have configed the business objects server
without technical support.  I used SQL procedures to separate the business
logic of the report from the reporting logic. That worked ok, but it was
still a lot of work. SQL views will also work well.

SQL server has a good reporting tool that I have never used but read about
as an alternative to crystal reports.




On Mon, Apr 22, 2013 at 8:30 AM, Hoteltravelfundotcom <
hoteltravelfun@xxxxxxxxx> wrote:

> Was interested in hearing how people find using CR with the AS/400.
>
> How do you make the connection is there any issues there.
>
> Do you use Logical views on the AS/400 or run SQL Queries. Assuming for
> dynamic needs from user, wants latest data.
>
> Do you make all formatting and data massaging on the AS/400 or do you use
> the formula features of CR.
>
> I heard that fastest method for CR is to use their parameters for
> filtering, is this so?
> --
> 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.