OraFAQ Forum: Reports & Discoverer » Matrix report columns from 2 fields in 2 diff tables

Home » Developer & Programmer » Reports & Discoverer » Matrix report columns from 2 fields in 2 diff tables

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Matrix report columns from 2 fields in 2 diff tables [message #136612]

Fri, 09 September 2005 00:42

priyravi
Messages: 41
Registered: July 2005

Member

Hi,

Is there a way to accomplish matrix report as flg.

Rows -- > one field from one table
Columns--> field1 from one table, field2 from another table.
Cells--> 'X' if condition matches.

Actually, I am getting as expected. But the problem is field1 and field2 are displayed as like

||field1 a || field1 b || field1 c||
||field2 a || field2 b || field2 c||

But I want in a single row like

||field1 a || field1 b || field1 c||field2 a || field2 b || field2 c||
ie, after all the values of field1 is displayed field2 should continue in the same line.

Help plz??

Regards
Priya

Report message to a moderator