views:

80

answers:

0

I am back in the Oracle 10g world and I need some help.

I have created a dynamic Oracle report calling from an Oracle Form that will output a tab delimited file, but I am having problems with the orientation of the column headers.

SET_REPORT_OBJECT_PROPERTY(RO_Report_ID, REPORT_DESFORMAT, 'DELIMITED')

I have no problem with the functionality of producing the report, but it outputs like this (I put the "|" in there for readability) Putting all the column headers before EACH ROW of date:

FirstName | LastName | Address | City | Rich | Smith | 123 test | Memphis

FirstName | LastName | Address | City | John | Smith | 392 Test | Memphis

FirstName | LastName | Address | City | Jane | Smith | 232 Test | Austin

How to I either force it to just add the headers 1 time as the first line and all the data under it like you would normally see it or dynamically shut off the headers from printing all together?