BusinessObjects Board

why can't i use a not equal condition on a where clause?

building reports desktopintelligence
#1

Hi,

I 'm trying to create a variable that filters out a specific sitename.

It’s giving me a syntax error if i use the <> symbol for not equal. Does BO not support inequality in a where clause?

= Where (<Sitename(Query 1 with Loyalty)> <> “Arclight”)

thanks.

srt6 (BOB member since 2003-09-17)

#2

Please, take a look at FAQ Reporter here.

Please, do a Search on BOB first before posting a question.

Andreas :de: (BOB member since 2002-06-20)

#3

You just can’t. Build a filter instead.

Steve Krandel :us: (BOB member since 2002-06-25)

#4

My apologies for not looking at the FAQ first. Did do a search and did not find anything on it, guess i need help on that too :slight_smile:

Filtering as Steve suggested works for me. I just got caught up the fact how a Where clause doesn’t take an inequality.

Thanks.

srt6 (BOB member since 2003-09-17)

#5

You can use a “<>” in a Join so it’s kind of strange you can’t use it in a WHERE clause, especially since the database allows it.

Iggy :us: (BOB member since 2002-10-24)

#6

It’s a WHERE option on a variable, not in a query. 8) BusinessObjects only supports =, and only against a constant rather than another variable.

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