Hi!
I've created two reports say report 1 & report 2. And, it should looks like this ->
YEAR QT P1 P2 ---- -- ---------- ---------- 2001 Q1 25 2002 Q2 13 14 YEAR QT P1 P2 ---- -- ---------- ---------- 2001 Q1 7 12 2002 Q2 10
And, my required final output should be ->
YEAR QT P1 P2 ---- -- ---------- ---------- 2001 Q1 7 37 2002 Q2 23 14
So, as you can see - i'm merging and adding the values of two reports into one.
I'm using Oracle 10g as my DB. Is it possible that i can write some SQL query any where in any place of the reports that can do this staff. Then i can go for that kind of solution, too.
But, in that case i need to know where to write the query. Please reply.
But, first -> Is it at all possible in BO?
Thanks again for your valuable time to read this post.
Regards.
Satyaki De.
Edited by: Satyaki_De on Jul 3, 2009 11:29 AM