OraFAQ Forum: Reports & Discoverer » adding sysdate while generate pdf file.

Home » Developer & Programmer » Reports & Discoverer » adding sysdate while generate pdf file. (6i)

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

adding sysdate while generate pdf file. [message #667349]

Thu, 21 December 2017 21:49

shahzad-ul-hasan
Messages: 643
Registered: August 2002

Senior Member

Dear
i want to create/generate a pdf/rtf file from reports.when appears save file dialogue i want to add sysdate with the file name.
please advised.

Report message to a moderator

Re: adding sysdate while generate pdf file. [message #667355 is a reply to message #667349]

Fri, 22 December 2017 00:13

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

That would be the DESNAME system parameter. I'm not sure you can set its value dynamically within the Reports Builder, so you'll have to create it in a program (Oracle Form, perhaps?) which calls that report.

Adding SYSDATE value (to a local variable which is later used in command you use to call the report) is trivial:

l_desname := 'my_report_' || to_char(sysdate, 'yyyymmdd') ||'.pdf';

Report message to a moderator

Previous Topic:	Matrix Report
Next Topic:	ORA-00600 internal arguments

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 12 02:33:04 CDT 2026