Skip to Content
0
Former Member
Jul 03, 2009 at 09:20 AM

Can i merge two cell in BO Reports?

87 Views

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