Saving a report to a file

[Guest_imported]

I'm attempting to save a report to a .LIS file (text-only), and the lines are being truncated to 80 characters, when I need them to expand to 132 characters. I'm calling the report from a form and sending it these parameters:<br>
<br>
ADD_PARAMETER(pl,'DESFORMAT',TEXT_PARAMETER,'WIDE180'); <br>
ADD_PARAMETER(pl,'ORIENTATION',TEXT_PARAMETER,'LANDSCAPE'); <br>
ADD_PARAMETER(pl,'DESTYPE',TEXT_PARAMETER,'FILE'); <br>
ADD_PARAMETER(pl,'PARAMFORM',TEXT_PARAMETER,'YES'); <br>
ADD_PARAMETER(pl,'MODE',TEXT_PARAMETER,'CHARACTER'); <br>
<br>
I'm also sending the report to the screen and the printer, and both of those functions work. Some of the things I've tried are:<br>
<br>
* Setting the DESFORMAT sys param to 'wide' and 'wide55' (just to see if it truncates it more - it didn't).<br>
* Openning the .LIS file in WordPad instead of Notepad.<br>
<br>
If anyone could help me w/ this, I'd appreciate it. Thanks.

 

[ryeolivier]

well, its really easy to save an oracle generated report to a file. you just have to install a generic text only printer in your windows environment, then add the print to text parameter from your oracle report designer to dump the output to a filename (being specified at runtime.)


hope i was of help.