OraFAQ Forum: Reports & Discoverer » Printing option in report

Home » Developer & Programmer » Reports & Discoverer » Printing option in report (Report bulider 10 g)

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

Printing option in report [message #473437]

Sat, 28 August 2010 05:38

Amar_bu
Messages: 32
Registered: July 2010
Location: riyadh

Member

In report builder, how could i specify that if i print the report for second time the report builder should write draft

Report message to a moderator

Re: Printing option in report [message #473460 is a reply to message #473437]

Sat, 28 August 2010 09:03

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

As my Understanding.

1- Add one column in Database
Print_Job char(2).

2- Update it through After Report Trigger (FR - Sc) Against Each Session User

3- Write Code Behind a Button
Check it Against Each Session User - It is First Time or Second time print and Validate it.

Hope you'll Get Idea.

Regards,

Irfan

Report message to a moderator

Re: Printing option in report [message #473470 is a reply to message #473460]

Sat, 28 August 2010 14:42

Amar_bu
Messages: 32
Registered: July 2010
Location: riyadh

Member

Thanks..but the problem that i could not edit the database

Report message to a moderator

Re: Printing option in report [message #473473 is a reply to message #473470]

Sat, 28 August 2010 17:31

cookiemonster
Messages: 13962
Registered: September 2008
Location: Rainy Manchester

Senior Member

Then you can't do this.
If you don't store in the db whether or not you've run the report, how are you going to know you're running it for a second time?

Report message to a moderator

Re: Printing option in report [message #473486 is a reply to message #473473]

Sun, 29 August 2010 03:27

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

As said cookiemonster Then you can't do this.

If you 've business needs then talk to your DBA regarding this Issue.

[EDITED by LF: removed invalid quote tags]

[Updated on: Sun, 29 August 2010 15:14] by Moderator

Report message to a moderator

Re: Printing option in report [message #473487 is a reply to message #473486]

Sun, 29 August 2010 03:40

Amar_bu
Messages: 32
Registered: July 2010
Location: riyadh

Member

Even If I am using Oracle ERP

Report message to a moderator

Re: Printing option in report [message #473702 is a reply to message #473487]

Tue, 31 August 2010 04:40

cookiemonster
Messages: 13962
Registered: September 2008
Location: Rainy Manchester

Senior Member

I don't know anything about ERP but the basic point stands:
If you can't record the fact that you've run the report somewhere you can't do this.

Report message to a moderator

Re: Printing option in report [message #473843 is a reply to message #473702]

Wed, 01 September 2010 01:50

Amar_bu
Messages: 32
Registered: July 2010
Location: riyadh

Member

I asked DBA to add the column for me.
He added print date column and i check it if it is null nothing will be done while if it is not not null draft word will be printed.

Another question if I want draft word to be printed in the background and i do not want other object to move with it when i run the report.what properties for draft text i should change?
Thanks

Report message to a moderator