How to merge rows that have logically continous data?

building reports webintelligence
1

Hi,
In my report date I have rows like:

c1 c2 c3

A 0000 1000
A 1001 3000
A 4000 6000

Here c2 to c3 is like a range.ie from 0000 to 1000.
Now for first 2 rows I have range in continous fashion.So Instead of displaying rows in above fashion.I want to merge the first 2 rows as
c1 c2 c3

A 0000 3000
A 4000 6000

Please help me out.
Thanks

nareshnookala :india: (BOB member since 2006-12-03)

2

Naresh,If i have taken your question correctly, then
by selecting 2 cells at a time which you want to merge,then select the merge cells option from properties tab.

otherwise can you explain the question clearly…

Thanks
MSR

KSReddy (BOB member since 2006-08-17)

3

Hello,
Thanks for the reply,but I don’t want to physically merge any cells using merge cells option.But I want the rows to be combined when the data is continous like abc def 1—5
abc def 6—8
abc def 9—16
cfg def 17–25
abc def 30—40
Here for above data in my query result.I want first 3 rows to be displayed as
abc def 1—16 because the numbers are continous and also the other 2 column’s have same values in it.

For 4th record as other attributes are different from first 3 records,even though the numbers are continous I will display it in a seperate row.

For 5th record as numbers are not in continuation with first 3 records which have same attributes,I would display them in a seperate row.

So finally my report should display

 abc def    1----16
 cfg  def    17---25
 abc  def    30---40

Please help me in solving this.
Thank you.

nareshnookala :india: (BOB member since 2006-12-03)

4

I think you can use Case When statement to recategorize the ranges (1-5, etc.).

Lilly J (BOB member since 2002-08-22)

5

Hello,Thanks for reply.I’m new to BO.So can u explain me the logic with an example with patience.

Thanks.

nareshnookala :india: (BOB member since 2006-12-03)

6

You can try this in the universe.

Case When in (1—5, 6—8, 9—16) Then ‘abc def 1—16’
When in (30—40) Then ‘abc def 30—40’
When in (17—25) Then ‘cfg def 17—25’
Else ‘Error’ End

You can also do it in the report. It depends on whether you create the report in Deski or Webi. The syntax is different. You can use If Else (Else If) then in Deski; in Webi you use If(condition;true value;false value). Hope this will be of some help.

Good luck.

Lilly J (BOB member since 2002-08-22)

7

Thanks that you tried to anwser my question.But I won’t be knowing the possible cases.I only know that if when first column values(text or number) and second column values are same in next ‘L’ lines and if the 3rd column and 4th column values(only numbers) are consecutive
like abc def 1 4
abc def 5 7
abc def 8 10
abc def 12 16 then I want only first 3 rows to be merged as

      abc def  1  10
      abc def  12 16  as 4th row numbers are not consecutive w.r.t first 3 rows.

Also where can I write these case when statements at universe level in XIR2

Thanks

nareshnookala :india: (BOB member since 2006-12-03)