Iloveoracle
Programmer
Hi ,
I designed a report to display the details for a given parameter list.In my report some part of data looks like a table with dynamic number of columns and rows.Actually if I am trying to creat a matrix report by using single query ,it will ask cell,row and columns fields. but now i have so many groups,thats why it is asking only groups instead of coulmn,row and cell fields.Table name and label are coming from other query ,at run time basing on that table name we have to display table detials.
So there is data link between these queries.
I am trying to insert report block of matrix type for this table structure.I couldn't select single fields for column ,row and cell values.
Its not showing like that ,when i am trying to create one matrix report block in my report.So i can select only group.
There is no option to select column,row and cell fields like single query matrix report.
So I selected G_COLUMN_SEQUENCE accross and G_TABLE_VALUE down and G_ROW_SEQUENCE down/accross
(There is no change if i select down/accorss or down for this group).Then I select displayed items are CLOUMN_NAME,COLUMN_VALUE and ROW_SEQUENCE.
But later I deleted ROW_SEQUENCE.Because I donn't need to display that in my report.
Now table looks ok for me( I mean row spanning is not a problem ,bec. i am not creating vertical lines).But problem is i am getting column
header for each row.How can i suppress duplication of column header.I want to display coulmn header only once .
It looks like this
column1 column2 column3 column4 column5 column6
----------------------------------------------------------
row1col1 row1col2 row1col3 row1col4 row1col5 row1col6
column1 column2 column3 column4 column5 column6
----------------------------------------------------------
row2spanning
column1 column2 column3 column4 column5 column6
----------------------------------------------------------
row3col1 row3col2 row3col3 row3col4 row3col5 row3col6
column1 column2 column3 column4 column5 column6
----------------------------------------------------------
row4col1 row4col2 row4col3 row4col4 row4col5 row4col6
column1 column2 column3 column4 column5 column6
----------------------------------------------------------
row5spanning
column1 column2 column3 column4 column5 column6
----------------------------------------------------------
row6spanning
column1 column2 column3 column4 column5 column6
----------------------------------------------------------
row7col1 row7col2 row7col3 row7col4 row7col5 row7col6
But I have to display like this:
column1 column2 column3 column4 column5 column6
-----------------------------------------------------------
row1col1 row1col2 row1col3 row1col4 row1col5 row1col6
row2spanning
row3col1 row3col2 row3col3 row3col4 row3col5 row3col6
row4col1 row4col2 row4col3 row4col4 row4col5 row4col6
row5spanning
row6spanning
row7col1 row7col2 row7col3 row7col4 row7col5 row7col6
I think I am misusing one repeating frame ,but I couldn't find that one.Please help to find that frame.
Thanks
GP
I designed a report to display the details for a given parameter list.In my report some part of data looks like a table with dynamic number of columns and rows.Actually if I am trying to creat a matrix report by using single query ,it will ask cell,row and columns fields. but now i have so many groups,thats why it is asking only groups instead of coulmn,row and cell fields.Table name and label are coming from other query ,at run time basing on that table name we have to display table detials.
So there is data link between these queries.
I am trying to insert report block of matrix type for this table structure.I couldn't select single fields for column ,row and cell values.
Its not showing like that ,when i am trying to create one matrix report block in my report.So i can select only group.
There is no option to select column,row and cell fields like single query matrix report.
So I selected G_COLUMN_SEQUENCE accross and G_TABLE_VALUE down and G_ROW_SEQUENCE down/accross
(There is no change if i select down/accorss or down for this group).Then I select displayed items are CLOUMN_NAME,COLUMN_VALUE and ROW_SEQUENCE.
But later I deleted ROW_SEQUENCE.Because I donn't need to display that in my report.
Now table looks ok for me( I mean row spanning is not a problem ,bec. i am not creating vertical lines).But problem is i am getting column
header for each row.How can i suppress duplication of column header.I want to display coulmn header only once .
It looks like this
column1 column2 column3 column4 column5 column6
----------------------------------------------------------
row1col1 row1col2 row1col3 row1col4 row1col5 row1col6
column1 column2 column3 column4 column5 column6
----------------------------------------------------------
row2spanning
column1 column2 column3 column4 column5 column6
----------------------------------------------------------
row3col1 row3col2 row3col3 row3col4 row3col5 row3col6
column1 column2 column3 column4 column5 column6
----------------------------------------------------------
row4col1 row4col2 row4col3 row4col4 row4col5 row4col6
column1 column2 column3 column4 column5 column6
----------------------------------------------------------
row5spanning
column1 column2 column3 column4 column5 column6
----------------------------------------------------------
row6spanning
column1 column2 column3 column4 column5 column6
----------------------------------------------------------
row7col1 row7col2 row7col3 row7col4 row7col5 row7col6
But I have to display like this:
column1 column2 column3 column4 column5 column6
-----------------------------------------------------------
row1col1 row1col2 row1col3 row1col4 row1col5 row1col6
row2spanning
row3col1 row3col2 row3col3 row3col4 row3col5 row3col6
row4col1 row4col2 row4col3 row4col4 row4col5 row4col6
row5spanning
row6spanning
row7col1 row7col2 row7col3 row7col4 row7col5 row7col6
I think I am misusing one repeating frame ,but I couldn't find that one.Please help to find that frame.
Thanks
GP