hi dear frends,
i've a report having one record per page. and i want this page to be printed twice, one having "ORIGINAL" and the other having "DUPLICATE" printed on the right corner of the report.
I'm trying the query that works in the sql like this
select A.SR_NO,'ORIGINAL' from ACC A,DUAL
UNION
select A.SR_NO,'DUPLICATE' from ACC A,DUAL
but doesnt work in the report.
can u pls tell me how to write this query in the reports data wizard.
pls do it with the example
thanx
bye