Home » Developer & Programmer » Forms » desformat and web.show_document (forms 10.1.2.0.2)
desformat and web.show_document [message #402138] Thu, 07 May 2009 16:34 Go to next message
dlwixon
Messages: 92
Registered: September 2008
Member

I'm trying to write a file to another server using web.show_document to run a report from a form.

I'm using web.show_document because our reports run on the server that I want this file.

I want the file to be a text file.

I have no problem doing this. However, I have to set desformat='delimited'.

When desformat='delimited', the lines in the report appear all in one line.

Is there a way to go to a new line for the fields in the report?


For example, I have 10 fields on the report. I want each field to appear under the previous field. I have it set up this way in the report.

However, for desformat='delimited', the text appears as follows:

text for field1 text for field2 text for field3 etc.

I want it to appear as

text for field1
text for field2
text for field3
etc.

Any suggestions?
Re: desformat and web.show_document [message #402703 is a reply to message #402138] Tue, 12 May 2009 02:28 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have you considered using 'utl_file'?

David
Previous Topic: double click
Next Topic: Migration forms 4.5 to 10gR2
Goto Forum:
  


Current Time: Fri Sep 20 15:35:12 CDT 2024