var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Crosstab Sorting Order
i have a crosstab query running, i then query this crosstab to obtain the layout i require.
i was getting results as shown below:
my months were displayed as 01/01/04 for Jan 04, etc i just need Jan 04 to be displayed as the data is for the whole month....
i have discovered if i use
this will do what i want, except for one thing
the months are displayed in the wrong order...
they appear like:
April, Feb, Jan,Jul, jun, mar, may
these are obviously being sorted in alphbetical order, can this be changed to sort by months as they should be
Try using the In() part of the crosstab .... Its far from perfect but it works...
Do not sort on the Field where you use "Format"...
Add and sort by the original Date field and if you do not need the date field, just make sure it doesn't appear in the results...