Iloveoracle
Programmer
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
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