Comments | rowyn: Why, Crystal? Whyyyyyy?

rowyn

Why, Crystal? Whyyyyyy?

Dec 31, 2009 11:12

( Cut for those who've heard enough of my ill-informed rantings about trying to program, badly, using reporting tools )

Comments 4

tetsujinnooni December 31 2009, 20:40:30 UTC

crystal uses very sql-like internal logic. "DISTINCT" in particular is an aspect of SQL. The thing to bear in mind (even if it's in the back of your mind) is that SQL is all about sets, not about processing individual items ( ... )

tetsujinnooni December 31 2009, 20:41:02 UTC

oh, and you'll note that DISTINCT wasn't needed for any of that.

jordangreywolf December 31 2009, 20:56:50 UTC

Ah, thanks so much for giving me a reason to be thankful I'm no longer working at a banking software company. ;D

tuftears January 1 2010, 01:04:57 UTC

I agree, it looks like you need to pick up SQL so that you can write your own queries.