INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...It's fun to see others going through the same stuff I did and be able to help. It's also a way for me to stay sharp and not lose the stuff I've learned..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > Development Tools > Oracle: Enterprise Developer Suite Forum

print job in reports

Read More Threads Like This One

bilalch (Programmer)

25 Oct 03 4:46

hi dear frend,

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.

plz help .

bye

brioska (Programmer)

28 Oct 03 5:44

possible it isn't the best...

make a subquery in your SELECT:

SELECT ...

      , ( SELECT 'DUPLICATE'
          FROM   DUAL
          UNION
          SELECT 'ORIGINAL'
          FROM   DUAL ) xy

...

it duplicates your rows
put it last in your ORDER BY, with DESC

make a field with xy source

bilalch (Programmer)

31 Oct 03 2:04

hi dear brioska

thanx for ur reply. for me it (the query) u've written just 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 subquery.

can u pls tell me how to write this query in the reports data wizard.

pls do it with the example

thanx
bye

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Oracle: Enterprise Developer Suite