| From report to text file [message #487278] |
Fri, 24 December 2010 09:38  |
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  |
 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
