Fog Creek Software
g
Discussion Board




Crystal Reports

I would like to create a simple (if i was using excel) report in Crystal.  Just an annual report, somethign like this:

        Jan  Feb  Mar  Apr  ...  Dec  Avg
ABC  1      3    5      2          3      3
XYZ  1      3    5      2          3      3
Avg  1      3    5      2          3      3

I hope that comes out... basically a *very* simple crosstab.  When I try to use the crosstab, I have a problem creating the last "Total Avg".  I think I'm using up all my summary fields (each of the monthly data points are averages).  They are, already, grand totals.  So I can't do one big average at the end. 

Is there another way to do a tabular chart like this in Crystal?  Using a crosstab seems like overkill for this type of chart, but it's all i can find.

Can someone please point me in the right direction?  Thanks.

nathan
Monday, December 15, 2003

After seeing my post, it might not be clear that I'm having problems creating the bottom row (Average for each month).  The averages column comes out just fine.

nathan
Monday, December 15, 2003

Nevermind - made a formula using the conditional variant of Average function.  I think I'm beginning to understand why people don't like Crystal...

nathan
Monday, December 15, 2003

It's never the software that people use that causes problems.  Never.  The software does only what it was told to do.  The real problem lies with the fact that you don't fully understand Crystal Reports and you also don't fully understand the intent of the programmers who created those functions you are trying to use.  Did those programmers say that they were going to create a function specifically for nathanj?  Newp.  They made some generic assumptions about what a vast majority of people needed and could make do with.  You simply can't blame "Crystal Reports".  The piece of software did nothing to deserve blame.  It's like when people say "I hate Windows".  100% of the time it is a misunderstanding between how the end user views what they want done and the way in which they want it accomplished, and how a programmer implemented the function in the software or interpreted the requirements of the end user.  Sometimes this miscommunication is alleviated by documentation, but most of the time it is not.  End users do not read documentation and simply expect the software to work the way they want.  A very sad situtation indeed, but a situtation that will not be eliminated any time soon.  When you call customer support, do you admit that you did something wrong?  Does customer support admit they did somethings wrong?  (Wrong as in a miscommunication.)  Probably not.  We would be lucky to run into people that are so humble.


Monday, December 15, 2003

(blank) - I disagree, if a software package is difficult to use and the documentation is poor or non-existant how can you blame the users for that??  The goal of a programmer is to make the application as easy to use and intutive as possible.

I have used many reporting packages and use Crystal almost every day. Crystal Reports is a good package but it has some major usability shortcomings and various "quirks" that makes it difficult to use.

DJ
Monday, December 15, 2003

Sometimes, you have to pay for flexibility.

Wayne
Monday, December 15, 2003

Dear Mr. DJ:

  Thank you for reading my post.  You obviously did not understand it.  How ironic.

Sincerely,

Mr. Blank


Monday, December 15, 2003

---"They made some generic assumptions about what a vast majority of people needed and could make do with. "---

The problem appears to be that for nearly all users who post on this forum at least they got those assumptions hopelessly wrong.

Stephen Jones
Monday, December 15, 2003

I have to say that Crystal Reports is the reason that I prefer a bit of code and PDFLib for my reporting solution.  Everything gets done a lot faster.  Crystal Reports is definitely a powerful package in the right hands, but my more basic solution is easier on every front.  Giving the unskilled user direct access to the database, as is needed for something like Crystal Reports to be useful, is not my idea of a good plan.  The large software installation is another reason that I'll pass on Crystal.

Clay Dowling
Monday, December 15, 2003

I've disliked Crystal reports for a long time, starting when I discovered it refused to format dates the way I wanted.

Seagate keep sending me new versions of this.  I keep adding them to the pile.  I actually loaded one the other day, and discovering it wanted over 60mb (at least!) did not endear it to me.

I had a contract where the were using it to run reports off an Access database.  I smelt resume padding.  I was right.  "You can do that in Access..."  Exit one developer & Crystal reports.

Does anyone still use it?

AJS
Monday, December 15, 2003

I also don't like Crystal Reports but I recommended to buy a full version of it. Reason? I don't know anything better than it. Perhaps, maybe, a company could compete and make their distributions free of bugs, I would have recommended others.

I am constantly downloading fixes of it because I hope someday it would fix our daily dose of bugs. Everyt time I apply a hot fix,  new bugs emerges.

Zaldy
Tuesday, December 16, 2003

Zaldy, what database back-end do you use?  (please don't say Access!)

AJS
Tuesday, December 16, 2003

I have always managed to get by with Infomaker. It has its quirks too, but the flexibility is 2nd to none.

Karel
Tuesday, December 16, 2003

Zaldy - Something better than Crystal?  Try Actuate, from www.actuate.com

Paul
Wednesday, December 17, 2003

http://www.datadynamics.com/Products/AR2/ProductTOC.aspx


Wednesday, December 17, 2003

*  Recent Topics

*  Fog Creek Home