I am experimenting with this module. First off, my cudos to the writer, what a fantastic piece of work!
One thing I can't get to work is adding multiple operations. when I add an alement to the 'op' parameter the module simple doesn't generate any results anymore. op => [ ['AVG', 'mycol'], ['COUNT','mycol']],
does not work while only adding the first one does. Is this a bug in 1.17 or am I missing something else?
I figured it out. I used DBIx::SQLCrosstab::Format for formatting the result into a list of simple hashes. Apparently this module cannot handle multiple operations. Simply calling get_recs() on the Crosstab object gives a perl data structure which does contain all the data. I'll go ahead and use that instead of the list of simple hashes.
Maybe this can be fixed in a next version of D::C::F