BusinessObjects Board

Multivalue in footer of Break

building reports webintelligence

system October 16, 2009, 6:37am 1

Hi,
I am having three column

Seq Break : number applied break on it.
Head : dimension this is for Heading

Range : dimension which is giving Multivalue error.

Seq break Head
o abc
DEF
#MULTIVALUE (tHIS FOOTER OF BREAK)

oUTPUT REQUIRED

Seq break Head
o abc
DEF
a.xxxx
b.yyyy
c.zzzz

a.xxx,b.yyy,c.zzz is a Range column
abc,DEF is a Head column
0 is a Seq Break

Kindly help.

Regards
Gunjesh

gunjesh (BOB member since 2008-09-15)

system October 16, 2009, 6:50am 2

use MAX() function in the footer.

Rakesh_K (BOB member since 2007-12-11)

system October 16, 2009, 6:55am 3

Hi,
Thanks for reply but I want to use all the value not Max Range.

Regards
Gunjesh

gunjesh (BOB member since 2008-09-15)

system October 16, 2009, 7:25am 4

go to the properties of the table, there is a property named something called aggregate or aggregation, chk that and try, or vice versa.
Hope it will work.

Zeenat (BOB member since 2007-12-11)

system October 16, 2009, 7:34am 5

Can you provide screenshot of your report, and screen shot of report in excel what you looking for. That will give us in understabding your requirement properly.

Rakesh_K (BOB member since 2007-12-11)

system October 19, 2009, 5:38pm 6

By all of the values, do you mean a sum?

bkaporch (BOB member since 2008-12-02)