break order setting problem in Matrix

[saketbansal]

Hi

i have matrix report with 3 groups
G_row:shows row headings
G_column:shows column heading
G_value:shows cell values

for row_heading column and column_heading column it is required to set break order property either ascending or descending

But in my case my Column_heading field order should be according to some other field as given in my query order by clause

In table:-
column_heading column_order

A 2
B 1
C 3


In matrix:

B A C


means my first Column_heading should be B then A next C
so i want to use (order by column_order) in my query

Thanks!

 

[nagornyi]

Include your column_order field in the column group, set break order by that field, but do not actually put the field on the report.

 

[saketbansal]

Thanks sir this one is solved as u told

But the second one still could not

Thanks Again!