Re: Reports 2.5 - Creating a delimited flat file

I used to do this quite a bit.
This is gonna be a challenge just to explain it! I'm assuming that you have two queries, the second based on the results of the first.

Ok

1. Create your queries in two seperate groups as you normally do with ||'|'|| separating the fields. Alias the two queries CSV1 and CSV2 or similar
2. Start creating a default layout with a tabular report. Put your field headings in the title field on the default layout wizard in a pipe-separated format. (e.g Empno|Ename|Job").

3 The CSV fields should be side by side. You then need to move the second CSV field and its related frames so it just overlaps the end of the first CSV field.

4. Ensure that their are no margins at the top and bottom of the page otherwise you will get huge spaces in your output.

5. You have to suppress the title frame and its repeating frame so it prints out on the first page only and then it 'contracts' on every other page.

6. You may have to make your fields so it expands horizontally to cater for extra long fields.

You may have to play with the fields to get your layout perfect.

HTH! Mark

Jenny Farnham wrote in message <7cbjdh$5hl_at_peabody.colorado.edu>...
>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 Mon Mar 15 1999 - 03:11:48 CST