Home » Developer & Programmer » Reports & Discoverer » Matrix Report with 2 column
Matrix Report with 2 column [message #454782] Fri, 07 May 2010 07:11 Go to next message
kame
Messages: 69
Registered: July 2009
Member
I want to create matrix report with 2 column

we can assign one column in matrix report my req is to assign 2 column .

example
Row Is FND
columns are Cdate & Ldate
Cells are Crate & Lrate


      CDATE    CDATE   CDATE   CDATE   LDATE    LDATE   LDATE
FND   01-MAR   02-MAR  03-MAR  04 MAR  28-FEB   31-JAN  31-DEC
-------------------------------------
ABC   CRATE    CRATE   CRATE   CRATE   LRATE    LRATE   LRATE
ABC   CRATE    CRATE   CRATE   CRATE   LRATE    LRATE   LRATE
ABC   CRATE    CRATE   CRATE   CRATE   LRATE    LRATE   LRATE
XYZ   CRATE    CRATE   CRATE   CRATE   LRATE    LRATE   LRATE
XYZ   CRATE    CRATE   CRATE   CRATE   LRATE    LRATE   LRATE
XYZ   CRATE    CRATE   CRATE   CRATE   LRATE    LRATE   LRATE




KINDLY GUIDE


Re: Matrix Report with 2 column [message #457199 is a reply to message #454782] Fri, 21 May 2010 14:30 Go to previous message
dude4084
Messages: 222
Registered: March 2005
Location: Mux
Senior Member
I suggest you to use UNION ALL in your query.

This will help you to combine both queries and will result matrix of your desire.


--Dude
Previous Topic: built in package
Next Topic: REP-52266, REP-50503
Goto Forum:
  


Current Time: Sat Aug 15 15:38:09 CDT 2020