Hi all,

Ok Ive definitely had it with Quick reports.... Ive gotten authorization to have a look at Crystal Reports so that we might purchase it but I have heard that it is sometimes limited in its capabilities (this may just be from earlier versions than the current one).

Has anyone used Crystal Reports extensively and can tell me the pluses and minuses and all that  or can someone suggest a better reporting tool that is quick and easy to use but still has the power I need...

At the moment we are using D4 likely to be on D5 soon and we are using Paradox and FlashFiler databases likely to switch to Oracle in the future.



P.S. Please don't answer this question until I let you know whether your answer is acceptable... I will let you know from your comments...
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

I was using VB/CR about 3 or 4 years ago, and I remember CR being very slow, and you couldn't embed it in your own window. (It's own frame had a unique look and feel that you couldn't change if memory serves me).

Maybe it's a hot potato now, so this is really just a "listening" post (cringe).

Let me know if this is good enough for an answer! hehe.  :-)

Hi, Gabe.

you're right about QR: it's like wearing handcuffs while programming (not that I know anything about wearing handcuffs!!!).

My company will be acquiring Crystal Reports in a few weeks. I hasn't been even evaluated yet, but we need to buy it anyway because our largest client needs us to deliver CR-aware solutions.

I have, however, evaluated another reporting tool that I liked VERY MUCH: ReportFX, from SoftwareFX (the same guys who created ChartFX). I have a demo version of it I can send you if you leave your e-mail. It's a sure winner and evaluating it is surely worthwhile.



Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
GabeinOZAuthor Commented:
Hey Alex long time no see....

That would be really great.....how much is the registration for it?

Our boss is pretty cool on the idea of CR as well because of the way clients can create their own reports with it...but like you said, we've not used it so I'm leary of how it will work for our end.  

Send the eval to gabe@rostima.com ...

Thanks mate

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Hi... Alex if is not to troublsome, can you sent me a copy of the demo you mention, I'm also in the mist of looking for a better reporting tools.

Anyway I'm giving you my email address


The file was sent last night. Let me know if you got it.

Crystal reports is your only real other option, and when I used it 2 years ago, it had its funnies like chopping off the las number of a long floating point value.. (we had to convert all floating points to strings and padd the buggers... what a mess) .. any way I have to admit that even that version is better than qrep 3.

My biggest pain at the moment wit Qrep is that reprint group on new page does not work, indeed the page counter does not work 100% ethier.. if you print the page counter on every detail , you will notice that some details that appear on teh same physical page have different page numbers... (that is a real mess)

go for CR

Rob ;-)

used CR in last 2 projects, short summary:

+ Easy and relatively quick to create reports.
+ Nice exporting functionality, i.e. export to html, rich text etc.(exporting to some formats may mess with the report layout)
+ Extensive Stored Procedure support for more complicated reports.
+ Strong filtering, sub-selection capabilities.
+ Users can create their own reports (yea right:)
+ subreporting strong
+ Crystal support is OK

On the other side.
- If you are retrieving a lot of rows it can be very slooow (design reports will to retrieve limited amount of rows, try to avoid left outer joins, use db indexing!)
- each report page is handled as a bitmap, don't even try printing on a dot-matrix printer. (we had to raise min requirements to include either LaserJet or inkjet printer)
- crpe32 report engine heavy on memory
- learning curve (on the more intricate reports)
- install has to be expanded to include ODBC driver, params, report engine etc.
- Can't change the SELECT or FROM clauses of a CR (with good reason though)

all in all:
Professional looking reports.
Pains in the buttocks is proportional to the difficulty level of the report - hey but that's the same with all reporting tools.

I would use cr again.

good luck:)
GabeinOZAuthor Commented:
ok thats alot of good information karoo....one more elaboration.....you mentioned odbc drivers.....is crystal reports only run through odbc? or will it handle native paradox tables?

Gabe, did you receive the file I sent oyu last night?

GabeinOZAuthor Commented:
Yeah I did mate and I had a look at it but it appears that it uses the odbc as well doesnt it?  Id really like to stay away from using the odbc if possible and especially if its just gonna be for our reports.



I've only used CR with Interbase and SQL server, can't comment on ODBC for Paradox but I would think it does. It's one of the "penalties" for using a third party reporting tool - I have to add it's not a big thing to install and configure the ODBC driver (especialy if your'e using an Install tool i.e. Installshield).
I am using ReportBuilder Pro 4.2 from DigitalMetaphors. I really like it alot. Very flexible. Works with many different databases. I am currently using Paradox and Oracle with it. It can also do straight from a text file.


GabeinOZAuthor Commented:
Ok Bozo I have looked at the tool you suggested.... looks really good but looks like a big learning curve and I just dont have the time.....

we have made the switch to crystal reports and have ordered version 7 but in the meantime I am getting a head start with version 6 and I have a question regarding it.... look for "Crystal Rep printing Group header"

As for this one I think Karoo has offered the most help in the direction I am leaning although really all of you helped me....Thanks for all the help guys...

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.