Home » Developer & Programmer » Reports & Discoverer » From report to text file
From report to text file [message #487278] Fri, 24 December 2010 09:38 Go to next message
MohWad
Messages: 9
Registered: February 2008
Junior Member
Hello everyone

I'm working on a report (written with Oracle report builder 6i) for the SMS system.
I want the the report results (list of mobile numbers) to be outputted directly into a text file.
I have accomplished that with the following parameters:
DESTYPE = File
DESNAME = C:\file_name
MODE = character
this work well for the first time but in the subsequent runs, the report rewrite the same file deleting the result from the run before.
can I manage to have each run result written in separate file with the name formatted in specific way like (sms_parametervalue_date) or something.
or at least is it possible to change the system parameter DESNAME via user parameter at runtime, so I can input the new file name into the parameter form (as a next best solution).

thank you
Re: From report to text file [message #490670 is a reply to message #487278] Wed, 26 January 2011 10:00 Go to previous message
banksilp
Messages: 6
Registered: January 2011
Location: 66
Junior Member
In my opinion,
This syntax could help you ...by programmatic in after parameter trigger
======================================
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESNAME,:P_TEXT_FILE_NAME);
======================================
regard,
banksilp


Previous Topic: run time sequence
Next Topic: Is there a way to pass 'Delimiter' ',' in Reports Builder?
Goto Forum:
  


Current Time: Thu Jul 02 11:50:40 CDT 2020