Database data display in Page Header section

[sandesh.dsouza]

Hi all,

 

I have to display various fields and values in the page Header section. The data what I want to display is there in a specific table say table1 as follows:

 

Col1 Col2

Field1: test1

Field2: test2

.....

....

....

 

First thing is I don't want to put this in details sections. It has to be in page header section. But the problem is I can use ${Col1} to display data put in the Col1. However I want to control this. In the sense, the report should look like this

 

 

Field 1: test1

Field 2: ..te..... to ..st2......

I want to have control ${Col1}. Is there any way to display data like this and at the same time get the subsequent rows and display the values wherever we need.

 

Thx in advance,

Sandesh