Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Reports 6i: producing HTML output

Reports 6i: producing HTML output

From: Noah Arc <bowed_zombie_drone_at_spam.begone.zombie.co.uk>
Date: Wed, 28 Nov 2001 09:08:42 -0000
Message-ID: <wQ1N7.285$sd3.177510@monolith.news.easynet.net>


Hello,

I'm trying to write a Reports 6i report which produces a HTML table as output, but am not really getting anywhere as I'm unsure how much "HTML-isation" reports adds to the output.

I'm stuck because I don't know how to specify each row of data. Does this need to be defined as 1 big row in the SELECT statement, like this:

SELECT '<td>Val 1</td>'||
'<td>Val 2</td>'||
'<td>Val 3</td>'||

...

... and use 1 field to display all the data, or should I define the columns separately, like this?

SELECT '<td>Val 1</td>' val1
, '<td>Val 2</td>' val2
, '<td>Val 3</td>' val3

Also, I've noticed that Reports hard-codes widths to each of the columns, but I don't want this as it's a big table which I know is going to be wider than the screen - and that doesn't matter.

The Online Help wasn't really much use - there are no useful examples that I could find.

Any help would be gratefully appreciated.

Thanks,

--
Noah Arc
Remove ".spam.begone"
Received on Wed Nov 28 2001 - 03:08:42 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US