Hi All,
i have a problem in creating a table report, where the column values needs to be displayed row wise. The following should explain what i am expecting:

I have a query :

select column1, column2, column3 from table1;
(This query will always return only 1 row)

Currently the report output(HTML) looks like this:

Column1 Column2 Column3
A 12 78


But i want my report to be like :

Column1 A
Column2 12
Column3 78

Is there anyway through which i can achieve the above format?


DDL for table:
Create table table1(column1 char(1),column2 number,column3 number);

TABLE FILE XXXXXX
PRINT COLUMN1
OVER COLUMN2
OVER COLUMN3
END

TABLE FILE WHATEVER
PRINT COLUMN1 OVER
COLUMN2 OVER
COLUMN3
END