Colun order in crosstab
Hi!
I created very simple crosstab report where columns represent months.
Obviously I want those columns to be in the order 'jan',
'feb',...,'dets', but they are sorted alphabetically (ie april,
august,...) despite my ORDER BY clause which sorts them by "month
number". How to fix this?
Another question - how to get rid of that "Sum of " in the
top left corner of the crosstab?
TIA
ain
I created very simple crosstab report where columns represent months.
Obviously I want those columns to be in the order 'jan',
'feb',...,'dets', but they are sorted alphabetically (ie april,
august,...) despite my ORDER BY clause which sorts them by "month
number". How to fix this?
Another question - how to get rid of that "Sum of " in the
top left corner of the crosstab?
TIA
ain
This discussion has been closed.
Comments
By definition, the crosstab component will order it's data alphebetically
regardless how the data is ordered in your dataset. A work-around to this
would be to create a new field in your dataset with the letters A - L in
order making this your master key. Then be sure A - Janurary, B -
Februrary, C - March... etc.
It is possible to customize the cells in a CrossTab component using the
OnGetCaptionText event. For an example of customizing individual cells in a
CrossTab, see demo 127 in the \RBuilder\Demos\CrossTabs\... directory.
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Few more questions about crosstab:
*) Is it possible to get rid of the very first row? It doesn't provide
any information and so just vastes space...
*) Is it possible to have more grand totals? I want to have Sum and
Average in grand totals, but only one value per cell in matrix.
*) How to print horisontal lines as well so that crosstab appears as
spreadsheet?
TIA
ain