Multi Records should Display in a Single Record

building reports webintelligence
1

Hi All,

I have a report with Columns Order, Amount & Text like below

Order…Amount…Text
-------…--------…------
100…10000…Sales
100…10000…on 10-Jan-2010
100…10000…in South Region

Requirement is like below

Order…Amount…Text
-------…--------…-------------------------------------------
100…10000…Sales on 10-Jan-2010 in South Region

Can you please let me know is there any option or work around is there to achieve this requirement?

SivakumarS :singapore: (BOB member since 2006-08-10)

2

Use Previous() function to concatenate the string and Max() to calculate neasure value.

Hope this helps you.

Rakesh_K :india: (BOB member since 2007-12-11)

3

The record count is not constant. For each order it may be 2 or 3 or 4 records.

SivakumarS :singapore: (BOB member since 2006-08-10)

4

If 4 ia maximum then create 4 variables using Previous() and again create a variable to concatenate all 4 variables.

Rakesh_K :india: (BOB member since 2007-12-11)

5

Follow below steps

  1. Create one measure object with "Text "
  2. Use this formula in {fn concat(Text column,’ ')}
  3. Goto Properties Tab Select Sum and uncheck Lov’s check box

patriot3029 :india: (BOB member since 2006-12-08)

6

patriot3029,

that is a really great tip! I had previously tried this using the GROUP CONCAT aggregate, but BO doesn’t recognise this as an aggregate and so does not put in the appropriate ‘group by’

one thing that would make it even better is if you could apply a sort to the concatenated values. I tried using the sort in the query pane of the properties tab of the object being concatenated, but that had no effect.

would this be possible?

Simon

twofivepie :uk: (BOB member since 2008-10-16)

7

I never tried but try with Break sort

patriot3029 :india: (BOB member since 2006-12-08)