Can i merge two cell in BO Reports?

[Former Member]

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

[Former Member]

I've to follow in this in the WebI Forum and hence i'm closing this thread here as answered.

[Former Member]

Hi friends,

Is there any update on this?

Regards.

Satyaki De.

[ted_ueda]

You didn't specify the reporting type. Nor do I think this is a SDK question, and you've posted in the SDK forums.

What are you using?

Sincerely,

Ted Ueda

[Former Member]

Thanks Ted.

I'm completely new to this BO. Bo version is XI Release 2.

I'm using WebI to generate the report.

>You didn't specify the reporting type.

What do you mean by this? Are you talking about whether it is a CrossTab (Matrix) report or not? Or anything else? Please explain.

>Nor do I think this is a SDK question

Even i'm not confident about that. So, i asked in my other thread whether i'm posting my problem in proper place or not. In case this is not the right place then can you share me the right link to post this problem?

Regards.

Satyaki De.

[ted_ueda]

It's recommended to first search the forums for related questions, then ask there.

I recommend going to Expert Forums >> BusinessObjects, and finding the forum relevant to your reporting type.

Sincerely,

Ted Ueda