BusinessObjects Board

supress query

hi all ,
i have a report in XIR2,is there any way to supress the query if there is no data entered for that particular query.???

Biku724 (BOB member since 2008-07-29)

Can you tell what is meant by suppress query when there is no data?


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

Also explain this too.

Jansi :india: (BOB member since 2008-05-12)

Did you mean you want to suppress the message that tells you that there is not data?

Then I dont think it is possible directly but you can do one thing, edit the SQL of the report and union it will the dual table query.

This will anyway give monimum of 1 row. You can hide the table contents if numberofrows() for that data provider is 1.

Omkar Paranjpe :us: (BOB member since 2006-02-13)

nice trick -:wink:

Naresh Ganatra :us: (BOB member since 2004-04-09)

Hi Naresh,

Yaah, This is been a trick, tried out a long time back, when we were asked to suppress the message by an user who dont like to see the message even though the user enters the combination of prompt values in such a way that it may or may not give any output. :hb:

Omkar Paranjpe :us: (BOB member since 2006-02-13)