We are in the process of migrating BO 5.0 reports to 6.5 and would like to minimize the number of Corporate Documents that we have. To do this it would be nice to be able to have multiple conditions in a query but have at least one mandatory and not all. This way users can select what they need from one report instead of having 5 reports that are identical with the exception of one object.
Is this possible? If so, how?
Thanks in advance!
CMGBOGirl (BOB member since 2005-05-03)
Conditions/prompts are not optional in Business Objects.
If a user does not want a condition they will have to go into the query panel and delete the condition.
Having said that, you can prompt the user and ask him/her which condition should be applied and get slick with combining that PROMPT condition and logically OR or AND it accordingly, for example (pseudocode):
( @Prompt ('Enter Choice',...) = 'Choice A' AND Condition1 )
OR
( @Prompt ('Enter Choice',...) = 'Choice B' AND ConditionB )
OR
...Andreas 
(BOB member since 2002-06-20)
Thanks so much for the quick response. I am really new to BO development and VBA but will take your suggestion and experiment with it.
Thanks again!
Tabatha 
CMGBOGirl (BOB member since 2005-05-03)
And welcome to B 
B
Andreas (BOB member since 2002-06-20)