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,

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

Original text of this message