
Formatting Crosstab with Crystal Reports
This seems like an absurd question, but I can't find the answer!
I am making a trivial crosstab off of a database, summing purchases by
month (rows) and year (columns). For the labels, I made quick
formulas using year() and month(). I found out how to format year as
a std. 4 digit number, and not 1,998.00 (a default setting? that's
kind of lame, why can't you format these labels directly?). But now
I'd like the months to be output as the month name. I can write a
formula that matches the given month number to an element in an an
array containing the month names, but then they're sorted
alphabetically. I can't believe there isn't a built formula to do
this! Not that it would seem to matter, the end result of mine is
essentially the same thing such a function would output.
Anyway, can I somehow force that label to be a date type, and output
in long format? I tried one way sort of like that, but it was no
help, the month() function returns a number, so the real date info is
lost. I just don't get this, this should be easy...it's such a
typical report. All the examples in the help file are reports like
type of widget versus state, none have a date on either axis, and the
formatting section ignores even the possibility that you'd want to
format those row and col labels.
Any tips would be greatly appreciated.
Dutch