report with group by and order by

[Iloveoracle]

Hi,


I have to display one tabluar form report with 5 feilds.For example col1,col2,col3,col4,col5.The report shold be group by col1 and col2 and order by col5.
Problem is any one of these cases is working .If Iu se simple query it gives order by col5,but col1 and col2 also displaying many times,I donn't want to repeat them,I have to make them as group item.If I create report with Group left format,it gives col1 and col2 data only once like a group object,but its not using order by col5.

Thanks
gp

 

[nagornyi]

In the lowerst level group of the data model, where col5 is, make sure the Break Order property of all fields except col5 is set no None, col5 should be set to Acsending

 

[Iloveoracle]

Hi ,

I changed everything to none except col5.But now I am getting error message like "Group G1 has no break columns".I have 3 groups like MAIN,G1 and G2.MAIN is the starting group.G1 is the group with col1 and col2.G3 is having col3,col4,col5.

thanks
Praveena

 

[Iloveoracle]

Hi,

I got the solution,its working fine now.

Thanks
GP