Change filename for attachement sent by Reports server
From: stef1711 <stef17111_at_hotmail.com>
Date: 28 Nov 2005 02:15:31 -0800
Message-ID: <1133172931.337682.279910_at_g44g2000cwa.googlegroups.com>
Hi,
Date: 28 Nov 2005 02:15:31 -0800
Message-ID: <1133172931.337682.279910_at_g44g2000cwa.googlegroups.com>
Hi,
I am using ORACLE FORMS and REPORTS 10g.
I am sending a mail containing the report result to different people.
Launching a report called 'TEST.rdf' in a form will create me a
file called 'TEST.rdf' attached in my email. So far everything is
working fine.
I want to have a file called 'DATA.csv' attached in my email.
What do I have to configure so that the file attached in my email is
having my chosen file name 'DATA' and is having my chosen file
extension '.csv' and is not having the name of the report
'TEST.rdf'
Can anyone help me to find a solution for this problem?
Find below the source code I am using to launch a report
Thanks,
Stephan
v_param := v_param || ' NC_CODE=' || my_code; v_param := v_param ||' DELIMITER=,'; v_param := v_param ||' MODE=CHARACTER'; v_report_id := find_report_object('TEST'); set_report_object_property(v_report_id,REPORT_COMM_MODE,ASYNCHRONOUS); set_report_object_property(v_report_id,REPORT_EXECUTION_MODE,BATCH); set_report_object_property(v_report_id,REPORT_DESFORMAT,'wide9000'); set_report_object_property(v_report_id,REPORT_DESTYPE,Mail); set_report_object_property(v_report_id,REPORT_DESNAME,v_email);set_report_object_property(v_report_id,REPORT_OTHER,v_param); reportserverjob := run_report_object(v_report_id); v_job_id := substr(reportserverjob,instr(reportserverjob,'_',-1)+1); v_rep_status := report_object_status(reportserverjob); Received on Mon Nov 28 2005 - 11:15:31 CET