Home » Developer & Programmer » Reports & Discoverer » adding sysdate while generate pdf file. (6i)
adding sysdate while generate pdf file. [message #667349] Thu, 21 December 2017 21:49 Go to next message
shahzad-ul-hasan
Messages: 536
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.
Re: adding sysdate while generate pdf file. [message #667355 is a reply to message #667349] Fri, 22 December 2017 00:13 Go to previous message
Littlefoot
Messages: 21439
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';
Previous Topic: Matrix Report
Next Topic: ORA-00600 internal arguments
Goto Forum:
  


Current Time: Sun Oct 21 02:57:48 CDT 2018