Re: Oracle Reports

1.

Select '"'|| emp.ename ||'","'|| emp.empno ||'","'|| dept.dname ||'"' CSV
from emp emp, dept dept
where emp.deptno = dept.deptno;

2.

Set mode = character and use a long page width size (1000) chars. Create tabular layout, WITHOUT any titles. Template = 'no template' or 'draft'

3.

Go into the margins and stretch the top and bottom margins to the top of the canvas (ie ensure that there are no margins). this is to avoid blank lines after every 64 lines or so.

4.

When you run the report, you should get a CSV layout as

"John Smith","0030","Sales"
"Seymor Butts","0040","I.T"

The CSV file can be read in Excel etc.

5.

In reports 6, there is an option to select delimited layout when you are running a tabular report. Delimeters are commas, tabs. I prefer the manual method where you can use any delimeter you like.

This is a start, there are other things you may need to do but I have run out of lunchtime to explain! And besides, referring to the original message in the thread, its a learning excercise for you ;)

HTH, Mark

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!