most flexible report layout control?

[GreenspanDan]

Hi,

I'm trying to build a series of reports that have a predefined layout, some of which are outside the parameters of what the report painter appears to be capable of, or at least, designed to do easily. i've read a little about free-form reports but haven't been able to get them to do what i want either.

for example, say i have a table with about 12 columns that i would like to be displayed in a grid:

--------------------------------------
col_01 | col_02 | col_03 | col_04
--------------------------------------
col_05 | col_06 | col_07 | col_08
--------------------------------------
col_09 | col_10 | col_11 | col_12
--------------------------------------

i can't seem to get this to work using the painter or using free-form reports.

since this is a web app i'm building, ideally i'd like total control over the html output, where i could write something like:

<table>
<tr>
<td>
<COL_01 (calling a value somehow)
</td>
<td>
<COL_02
</tr>
</table>
(etc)

 

[WFGuru]

Try this.

PRINT
COL_01 AS ''
COL_02 AS ''
COL_03 AS ''
COL_04 AS '' OVER
COL_05 AS ''
COL_06 AS ''
COL_07 AS ''
COL_08 AS '' OVER
COL_09 AS ''
COL_10 AS ''
COL_11 AS ''
COL_12 AS ''

 

[GreenspanDan]

perfect, thank you!