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
Messages: 580
Registered: August 2002
Senior Member
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
Messages: 21678
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 Jun 20 20:37:53 CDT 2021