Matrix Rep with Grouping in ROWS

[saketbansal]

Dear ALL,

i have one report (matrix) which has groups in row now the problem is whenever the row group ends column get repeated

The output comes like this
C1 C2
Gr1
R1 v v
R2 v b
-----------------
Sum() sum()
C1 C2 -----------> I don't want this to come
Gr2
R1 v v
R2 v b
-----------------
Sum() sum()

I want output like

C1 C2
Gr1
R1 v v
R2 v b
-----------------
Sum() sum()
Gr2
R1 v v
R2 v b
-----------------
Sum() sum()

is there any way to get this

 

[nagornyi]

In the data model, insert summary field to the group preceding the matrix. The summary (let's call in CS_1) would count the column that gives rise to the group.
Then go to the format trigger of each matrix column label and replace
return (true);
line to the following line
if :cs_1>1 then return false; else return true; end if;

 

[saketbansal]

Thanks
for ur reply actually i want to repeate the column headings for every page only once So can't we do something related to Page No.

And i could not undrestand the above explanation becuase the group break rise when the value of group field changes.So how cs_1 works with counting columns?

Please make it clear...

Thank u very much in advance.

 

[nagornyi]

Try using not "Matrix with group" standard report type, but just "Matrix". However, inside the matrix you have to define groupped row structure. To do this, in the report wizard define on the Rows tab:
Layer1 --> Move here field that gives rise to Gr1, Gr2
Layer2 --> Move here field that gives rise to R1, R2.
The rest of matrix to be as in your report.