BusinessObjects Board

Use of "Where" syntax within a report variable.

building reports desktopintelligence
#1

Hi

I have a report with the following local variable (v_MinWeek) defined:

=Min() ForAll

But if I try to use this within another variable, i get a syntax error:

= Where (<Rptg Week(Main)>=<v_MinWeek>)

Any advice would be greatly welcomed. Thanks in advance.

Tom Schofield.

tomschof (BOB member since 2003-12-04)

#2

The right hand side of a where can ONLY use a constant, not a variable or other object. Try this post for a more thorough explanation and a workaround.

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

#3

… or this entry from the Reporter FAQ. 8)

Adding additional types of conditions on the “where” clause can be a bit tricky, but there are many examples either here or on the web. The bottom line is that the “where” clause will only work with = and only with a constant on the right side of the expression. So you simply make up a new variable that has all of your logic, then reference that variable in your where clause.

Dave Rathbun :us: (BOB member since 2002-06-06)

#4

Thanks both - much appreciated.

tomschof (BOB member since 2003-12-04)

#5

Yes, very helpful indeed. 8)

Dirk :south_africa: (BOB member since 2002-06-26)

#6

you can’t do with bo syntax like “… where <vars_01>=<vars_02>”

but you can do where <vars_01>=cte

so, you have to operate in a differente way

try this tutorial, maybe it could help you

http://www.romanov-memorial.com/Virtual_Manor/R2/bi/tips_businessobjects_01.pdf

bernard timbal :fr: (BOB member since 2003-05-26)

#7

…which turns out to be completely unuseful as it is in French… Daar kan ik (en waarschijnlijk meer dan 80% van de wereld) dus niets mee…

jobjoris :netherlands: (BOB member since 2004-06-30)