Printing in One row

[pashu]

Hello Freinds,

I've developed the report ,my database is oracle 8i thru view.The report currently printing looks like below-

Apr May
Eno Ename Paid_days value Gross Paid_days value Gross
1 xyz 30 60 5000
31 75 6000..

The report should print in foll. manner-

Apr May
Eno Ename Paid_days value Gross |Paid_days value Gross
1 xyz 30 60 5000 | 31 75 6000

The above print the details of an employee from apr to sep in one row as shown above.Can anyone extend help.Waiting for ur valuable reply ASAP.Thanks in advance.

Regards,
Pashu.

 

[lbass]

If these are detail level records, and you have a group on {table.Eno}, you could right click on each field/formula and insert a summary (sum) so that the results appear in the group footer. Then suppress the details section.

-LB