how to show spanning rows in the dynamical table format in the report

[Iloveoracle]

Hi,

I designed table format by using matrix query.The table structure comes dynamically ,its not fixed.table is having diff. number of coulmns and rows depending on the parameters we are passing.Now i can display table with columns and rows.But the problem is some rows are spanning between the columns.For example I have data like
(row1,col1)="admin"
(row1,col2)="masters"
[colour red](row2,col1,col2)="technology i_Q is [/colour]conducteing this week"
(row3,col1)="science"
(row3,col2)="Interest"


I think u may understand the above data,1st and 3rd row data is coming in corresponding columns .But row 2 data is spanning between two columns.it means row2 data is spanning between column1 ,column2.
So how to display spanning rows in this situation.One more thing i need to menshion here is,tables and its rows ,columns everything are coming dyanamically,not fixed.Here I discussed for 2 columns only.but remember this number is not fixed.

Thanks in advance.
GP

 

[Iloveoracle]

I am giving more information regarding to the above problem. I have a column called colspan in the database table.If colspan=2 means the cell value in that row is expanding between column1 and column2.if colspan is null means the cell value is in the corresponding row and cell only.Can any body help me please.

Thanks in advance
GP

 

[nagornyi]

Unfortunately, there is no way in Oracle Reports to do this. The only conceivable way to get the report like this would be to render the data into Excel, and then use macros to merge cells.