Re: Reports and CSV

From: Miggins <mtproc_at_yahoo.co.uk>
Date: 9 Mar 2006 03:37:45 -0800
Message-ID: <1141904264.949152.5710_at_i40g2000cwc.googlegroups.com>


Hi,

I am trying to run a 9i report from forms 9i. This report is to purely generate a CSV file. Currently setting the following report object properties but the form is still not running.

report_id := FIND_REPORT_OBJECT('REPORTNAME');
SET_REPORT_OBJECT_PROPERTY(report_id,report_filename,:b0.report_id);	SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_COMM_MODE,SYNCHRONOUS);	SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_SERVER,vReportServer);
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESTYPE,'file');
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESFORMAT,'DELIMITED');

Has anyone done this before, if so any help would be greatly appreciated.

Thanks Received on Thu Mar 09 2006 - 12:37:45 CET

Original text of this message