I don't think you're being fair, what i suggest you retitle your comment as

Crystal Reports is absolutely f&^%ing shite.

I hate this software soooo much as probably every developer who has to use it.

Looks more like Intelligent Design to me, however seeing as it's Crystal we're talking about it's better to attribute it's "success" to random processes than conceive that it was actually designed.

stands well back...

I hate Crystal Reports. As a developer it's been the bane of my life both in terms of development and deployment.

***"I have to say, I've found it to be pretty useful in the past. Within its limits, it's not too bad."***

Well, the installation CD makes a reasonable coaster to stick my coffee mug on. About all CR is good for, IMHO.....

.. who claimed he liked crystal reports. He's now selling insurance door to door because it's less stressful.

Do yourselves a favor , take it off your cv and get an "Expert in" to sort it out for you.

Awful, awful, awful, I need another shower just thinking about it. I was using it for just simple reporting, well within it's "limitations" and found I'd always end up writing database views for it to run on because you often couldn't format fields or build simple joins correctly. And if you did try and join anything using it's visual linking expert thing it'd automatically decide to join every field on every table to pretty much every field on everything else, completely undoing all your manual joins in the process. Urggh.

I don't get it. What is to hate??

You write a query then use Crystal reports to make it look pretty for the user. It's not the most complex thing in the world.

I think you guys are either trying use it in a solution for which it is not meant to be used, or you are just not bothering to learn how to write reports in it.

Sorry. I rate Crystal very highly.

***"I don't get it. What is to hate??"***

It was pushed as an 'Enterprise' solution and marketed as such but is almost useless for anything more complex than simple desktop reports onto a relational database.

3-tier and n-tier architectures, forget it.

***"I think you guys are either trying use it in a solution for which it is not meant to be used."***

Quite probably. But that has more to do with the way it pushed (and swallowed by "IT illiterate management staff"). I reiterate, its useless for anything other than trivial desktop reporting directly onto a relational db.

***"or you are just not bothering to learn how to write reports in it"***

Oh no. That's the *easy* bit. Getting it to *run* the f'ing report is the problem.

I think everyone here who has used CR in anything other than the most trivial manner must have spent time banging their heads on their desks going "Feck, Feck, Feck, Feck, Feck" because every time you think you have sussed out how to do something straightforward with CR's shitty API, it flings another flaming hoop you need to jump through just to get your data to the report.

What a bunch of clowns. Crystal reports is THE most flexible reporting solution on the market. Why do you think it's embedded as the reporting engine of half the off the shelf software out there?

I've worked with the rest of the Business objects suite as well as Cognos and those products try to be too clever for their own good. Has anyone ever actually managed to build a meta layer that doesn't need constant development to stop it from being a random number generator?

So what if you need to build database views and the occasional stored procedure underneath a report. That shouldn't be a problem to any useful developer. Unless you're developing off a datawarehouse then of course the structures arn't going to be ideal for reports!

Muppets.

"Why do you think it's embedded as the reporting engine of half the off the shelf software out there?"

For much the same reason that McDonalds bundle cheap tat toys with each Happy Meal.

The kids (for kids read "IT illiterate management staff") think its cool and want to buy the product that it comes with.

Crystal was fairly good when it was bundled with VB4 and even VB 5. Then it grew, a lot. If you were writing a little database app in VB it would fit on a couple of floppies until you added Crystal, then you went out and bought a CD burner...

Seriously, if you need to knock up something very quickly in a MS/SQL environment, MS Access has a pretty good band report generator - Bundling up the whole Access run-time environment takes up less space than Crystal, and it seems to be about an order of magnitude faster.

I lost interest in Crystal v6 when I discovered it was IMPOSSIBLE to change the DSN a report used to connect to a database programmatically in C++. Bear in mind it was touted as an "Enterprise" solution, then having a calling application being able to specify which database to use shouldn't even be an issue. When I asked Seagate (as 'twas), they kept on replying with examples in VB.

In the end we had to maintain 3 copies of reports, one for dev, one for UAT, and one for live. For every customer.

And don't get me started on how Crystal "helps" developers by making changes to reports, even though you've located that "please mess this report up so it needs rewriting from scratch" checkbox.

It is so not able to do what it claims to be able to do. Unfortunately it's the MS Access of the BI world. Managers think they can use it, so it becomes the company "standard".

I hope the fact that SQL2005 SRSS is free will cause managers to switch to that, and consign Crystal to the dustbin of history.

I'd be intrigued to here peoples views on Alternatives.

We use SQL Server 2005 reporting services, and I can't say

that I've got any good words for that either.

>What they fail to understand though is that if they are having problems

>learning to use one of the most powerful reporting tools out there, it's

>their problem and a failure on their part to learn to use it correctly. There

>is a reason it's so popular you know.

Popularity isn't a reason to purchase a product. I've seen plenty of purchasing managers suckered by the sales pitch of "Fortune 500 Company X is using it and they love it" and buying it after a hasty (crap) demo.

I suspect folks that are pissing and moaning are doing so because someone else saddled them with the tool and said "Make it do this! The vendor said we could" after a demo like that.

Crystal does one thing very very well. It takes a query and makes it presentable to your end users. When used like that it's a valuable tool. When coupled with tools like business objects (DeskI or WebI) or Microstrategy and a business plan that allows the tools to play to their strengths it becomes even more valuable.

Having been saddled with a "one tool fits all" environment, I can see why folks would be pissed (it was microstrategy in my case, which sucked at handling presentable reports).