Shallowbottom

The nonsensical ravings of a lunatic mind.

I Hate Crystal Reports

The company I work for began using Crystal Reports some years back, and not being a “report writer” I didn’t care too much at the time.  Now, of course, that inattention is biting me in the backside because I have inherited the task of redesigning a couple of those reports.  That alone should be pretty humbling since I am a “software engineer”, not a danged “report writer”.  These reports have a fairly intricate amount of line drawing in them to create a “form” look for the generated report which undoubtedly causes some of the headaches with redesigning these.

I can proudly state that I am pretty inexperienced with Crystal Reports (or any other reporting software) so perhaps I am bringing some of this upon myself, but this has to be the most damnably frustrating piece of …. software …. I have ever used.  There are SO many things that can go wrong.  Fonts can get you (oh, it will “work”, but may not look ANYTHING like you designed).  Permissions can get you (sometimes to system folders).  Disk space free in unexpected places can get you.  Bad reporting fields can get you, which is okay but you think it would tell you which one!!!  HA!!!  If only!  And don’t you go changing any of the default behaviors for a report.  That’s a certain death wish.

You have to know something of redistributing the right runtime version of Crystal Reports on the client machine, and of course they have “upgraded” Crystal Reports like they were changing underwear.  Is it v8?  v9?  v10?  vX?  Visual Studio 2003?  Visual Studio 2005?  Dog crap?  (Yes, it IS the latter!).  Have you installed service packs?  Hotfixes?  The list goes on and on and on.

With all the bells and whistles this thing claims to have you think it would at least be WYSIWYG, but regrettably it is not.  Design to your hearts content, then see the deployment have not so subtle and catastrophic affects on the output.  It can easily make a report you spent weeks perfecting look like some piece of garbage somebody threw together in an afternoon.

I read a blog entry recently where some sap claimed the inclusion of Crystal Reports into Visual Studio had “made the programmers life so much simpler”….. I’ll bet the poor sucker has not tried to deploy that sumbuck to another computer!

By the way, did I mention I hate Crystal Reports?

January 30, 2008 - Posted by shallowbottom | Life - Or Something Like It | | 6 Comments

6 Comments »

  1. Me too. I’m now spending hours try to find why I have the explicit message error “The Report Application Server failed” ! I change, re-change and re-re-change everything but always always always this !@#$% message with no explanation !

    Comment by Dada | June 3, 2008 | Reply

  2. I hate Crystal now that they have gotten bought out by SAP. I hate you SAP! SAP has the worst service. Also, they have changed all of the links for Crystal Reports.

    Comment by SF | October 15, 2008 | Reply

  3. It seems to us that Crystal’s sale to SAP will only make things worses.

    Our company does custom development for clients and I can’t tell you the number of times we’ve spent more time (and money) doing the Crystal Reports work than we spent building the original application.

    Don’t get me wrong – Crystal Reports is an extremely powerful product – but you damn near need a Phd. in CompSci to get it to play nice with other systems right out of the box.

    Add to that the licensing fees – the ’solution’ quickly becomes cost-prohibitive to all but the largest companies.

    In direct response to this specific problem with CR we ended up creating our own application (http://www.bluyah.com) to handle the basic reporting needs of our clients – and solve quite a few problems Crystal couldn’t solve for them as well – like XML data transformation to feed data from one system into another.

    I would say that I ‘hope’ CR changes its ways and becomes more attentive to its under-served small and medium business clients’ needs – but truthfully, I hope they keep going they way they are going. It will only mean more users for our application and others like ours.

    Comment by Richard Luck | February 27, 2009 | Reply

  4. We’ve developed an online reporting tool called Bluyah. If you’re looking for an alternative to Crystal Reports, please give us a try and let us know what you think.

    We’re eagerly looking for feedback and will take your suggestions very seriously.

    -Brad

    Comment by Brad | February 27, 2009 | Reply

  5. Man, I am *right* there with ya.

    Comment by James | March 10, 2009 | Reply

  6. All I want to do is use a subquery to list people who have not bought a particular item. Can’t do a subquery. Have to do some type of awful sub-report (which I cannot get to work properly). simple joins? No problem? a *little* more complex? Forget it. Argh!

    Comment by Totally Frustrated | October 27, 2009 | Reply


Leave a comment