Re: Equivalent products to SQR?

[ANDREW LIROT <andrew_lirot@YAHOO.COM>]

Actuate, although expensive, offers a complete
reporting solution.  I have worked with SQR, Crystal,
etc. and it far outmatches those tools in the areas
of:
1. Development Environment - its dev environment is
based on VB 3 while offering OO extensions.  Can
connect to multiple data stores.  Visual / Procedural
dev environment may pose steep learning curve for
non-propeller heads.
2. Security Server Admin- the server side can handle
the full range of admin chores, or hand them off to an
LDAP app through their APIs. Scheduling, etc. Page
level security.
3.  Distribution - Strong Web features, including a
complete URL based report requesting, no client, DHTML
rendering server process.
4.  End user navigation Niceties- Hyperlinking, Table
of contents, Search and download.  Professional
Formatting.

Like I said the soilution is a little rich.  30-50K a
processor.

--- John Milardovic <milardj@SX.COM> wrote:
> I would second that suggestion.  I recently created
> 5 operational reports in
> perl and it was a snap.  I also benchmarked a perl
> report against an
> identical SQR report (see attachment).   I found
> also that I could
> DRASTICALLY increase the time that perl reports took
> if I scrapped joins and
> instead joined the rows programmatically (one report
> went from 2-3 minutes
> to about 30 seconds - although perhaps better
> indexing of the tables and
> better use of existing indexes would have worked
> also).
>
>
>  <<Perl vs SQR Benchmarking.doc>>
>
> HTH
> John Milardovic
>
> > -----Original Message-----
> > From: cshelton [SMTP:cshelton@INDIANA.EDU]
> > Sent: Monday, October 09, 2000 10:34 AM
> > To:   SQR-USERS@list.iex.net
> > Subject:      Re: Equivalent products to SQR?
> >
> > I'd suggest looking at perl.  I've been working
> with both sqr and perl for
> > about 4 years now. Even though perl might have a
> slightly steeper learning
> > curve than sqr, it can do everything that I know
> that sqr can do and a
> > whole lot more.
> >
> > Try starting at www.perl.com and www.perl.org for
> researching perl.  In my
> > experience, support for perl is significantly
> better than with sqr,
> > especially if you are able to search on the net
> for answers.
> >
> > The two biggest issues that I see in favor of perl
> over sqr are total cost
> > of ownership and control of software.  For the
> cost of one SQR license,
> > you can buy quite a library of perl books, as well
> as attend training
> > sessions or even bring in an on-site firm to train
> people in perl.  Since
> > perl is open source software, you don't have to
> pay any organization for
> > the right to use it.
> >
> > Eric Scott Raymond described the control issue
> well, in his recent talks
> > about this issue:
> >
> > "An executive who allows his company to becomes
> dependent on software he
> > is not allowed to see inside, let alone change,
> has lost control of his
> > business, and is on the wrong side of a monopoly
> relationship with a
> > vendor who can thereby control his business. With
> open source, the
> > executive is in control, and nobody can take that
> away. "
> >         - Eric Scott Raymond, "Meme Hacking for
> Fun and Profit"
> >
> > Chris Shelton
> >
> > On Mon, 9 Oct 2000, Chris Gin wrote:
> >
> > > Hi,
> > >
> > > We have been forced into looking at replacing
> SQR due to the change in
> > the
> > > licencing structure by Brio. Currently we run
> SQR on Unix and we're
> > looking
> > > at migrating to an NT environment.
> > >
> > > Are there any products out there that even come
> close to SQR in terms of
> > > functionality?
> > >
> > > The reason we're looking at using something else
> is because we're told
> > that
> > > the cost of a user licence is now based on the
> power of the machine it's
> > > running on. For us, this means an increase of
> 1000% which is ridiculous.
> > >
> > > Thanks,
> > > Chris
> > >
> > >
>

> ATTACHMENT part 2 application/msword name=Perl vs
SQR Benchmarking.doc



__________________________________________________
Do You Yahoo!?
Get Yahoo! Mail - Free email you can access from anywhere!
http://mail.yahoo.com/