Reports 2.5 - Creating a delimited flat file

I want to create a simple master/detail Reports 2.5 report that outputs an ASCII pipe "|" delimted file.

I can DO this in sql*plus, however, the company requires that we use Reports 2.5.

In sql*plus I do something like:

select field1 || '|' || field2 || '|' || field2 from table
etc.......

How am I going to achieve this in Reports 2.5 when some of the fields come from the master query and the other fields come from the detail query? I know this is a matter of thinking differently!

Thanks for any hints or even examples? you could send in .rdf format.

Jennifer Received on Fri Mar 12 1999 - 11:37:53 CST