OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » 2 Records in 1 Row (Reports 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

2 Records in 1 Row [message #291764]

Sun, 06 January 2008 12:13

gynanda
Messages: 33
Registered: November 2007

Member

Hi,

My Requirement is:

First invoice should be printed in the first 3 columns and the second invoice should be printed from 4th to 6th column. Third invoice should be printed in the second line from 1st to 3rd column. Fourth invoice should be printed in the second line from 4th to 6th column and so on

Inv_No1 Inv_Date1 Inv_Amt1 Inv_No2 Inv_Date2 Inv_Amt2
Inv_No3 Inv_Date3 Inv_Amt3 Inv_No4 Inv_Date4 Inv_Amt4
Inv_No5 Inv_Date5 Inv_Amt5 Inv_No6 Inv_Date6 Inv_Amt6

Can somebody help me how to do this?

Thanks in advance.
Nanda

Report message to a moderator