BusinessObjects Board

Dynamically alter report structure

building reports webintelligence
#1

Hello

I can use a combination of IF, DrillFilter etc functions in a formula to establish which drill filters are applied and hence work out what formula to display … or display nothing.

Is it possible to use similar functionality to alter the table structure itself. What I want to be able to do is have break footers turned off when I’m at a certain point in the drill hierarchy (when a certain combination of drill filters is in place)

At the very least is it possible to alter the height, colour, borders of a row based on a formula … I’ve tried alerters but don’t think I can alter the height.

Any ideas?

Cheers

Mike

mick66 :uk: (BOB member since 2002-10-16)

#2

You can only change background color, font etc and cannot change height/width using alerters
You can try doing a white-on-white using alerters in order to hide break footers. Not sure how far its workable.

.

haider :es: (BOB member since 2005-07-18)

#3

Im not sure if this applies to your situation, but Ive found block level filters very useful whenever I want to control the report display based on conditions.

Chk my post here:-
here

Roshknee :india: (BOB member since 2007-10-29)