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: 502
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: 21332
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
Goto Forum:

Current Time: Sat Jan 20 04:30:32 CST 2018

Total time taken to generate the page: 0.02693 seconds