Re: Reports --> EXCEL

From: <mgumbs_at_hotmail.com>
Date: Tue, 10 Aug 1999 11:58:17 GMT
Message-ID: <7op44l$5rs$1@nnrp1.deja.com>

You can create a CSV file of your report by

Appending commas after each field and aliasing the whole query

select empno ||','|| ename, ||','|| job CSV_Line from emp;

2 Creating a default tabular layout and embedding commas after each field (a bit more fiddly).

Look at reports help in what settings to do when creating an ascii report.
Remove margins etc.
Save the output to a file.
You can then use OLE automation to kick off excel with this filename.

HTH, Mark

In article <01bee264$f5607960$6e49100a_at_pc910-sode.seurope.ikea.com>, "Kai Sodemann" <Kai.Sodemann_at_memo.ikea.com> wrote:
> Hi,
> I'm working with REPORTS 2.5 and want
> to create a file based on the data that is in the report,
> that can be opened by MS EXCEL.
>
> Any concepts or basic ideas are welcome.
>
> Thanx Kai
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Aug 10 1999 - 06:58:17 CDT