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: 615
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: 21806
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: Thu Mar 28 06:37:26 CDT 2024