Message:
: Hi : I had a problem in reports 2.5 version. : I written a query; : select deptno , ename , designation,sal from emp order by designation; : Its coming out put as follows: : deptno : 10 : Ename designation Salary : ----- ----------- ------ : PETER Manager 10000 : Micheal Manager 10000 : Bobby Manager 10000 : Julie sales 50000 : Caron Purchase 20000 : : I want to put a Line break (1 line space) between designation change. : (condition is , i dont want to change the default layout wright now : i want to do using script or using any properties ) : I need output like this ; : : deptno : 10 : Ename designation Salary : ----- ----------- ------ : PETER Manager 10000 : Micheal Manager 10000 : Bobby Manager 10000 : --- here you can see the Line break. : Julie sales 50000 : --- here you can see the Line break. : Caron Purchase 20000 : : How to do this ?? : Please give the solution i will he happy. : thankx : by : suresh.