Group of prompts

Hi,
Could some one please suggest me how to resolve the below issue.

In one of my report the user needs to select a group of prompts to run the report.
e.g
Group A
Prompt 1
Prompt 2
Prompt 3

Group B
Prompt 4
Prompt 5.

The user should be allowed to choose either Group A or Group B to run the report and user should not be allowed to mix and match the prompts.

Is there any way I could display both group of prompts and let user pick his choice and run the report.
I am aware that Prompts in Business Objects MUST be filled out.

I tried searching BOB for “optional prompt”,“default prompt” and “prompt validation”, but couldn’t get any clues to my problem.

Any help is highly appreciated.
Thanks
Leo


Leo :us: (BOB member since 2004-01-07)

Just create two separate Business Objects documents: one with prompts for Group A, another document for prompts for Group B.


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

Thanks for your response Andreas, But the user wants this functionality in Single BO report.
Please throw some light on this.
Thanks
Leo


Leo :us: (BOB member since 2004-01-07)

I do not see any solutions without using SDK - maybe, someone else has some suggestions?


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

Shouldn’t something like:
(Value 1 = @prompt1 AND @Prompt2=’%’) OR (@prompt1=’%’ AND Value 2 = @prompt2)
get the result you want (where endusers will have to enter the ‘%’ in one)? At least it should restrict them from combining your prompts.


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

Thanks for your response Andreas and jobjoris.
jobjoris Each group has unique prompts, I am not sure how can I use your suggestion.
could you please elaborate.
Thanks
Leo


Leo :us: (BOB member since 2004-01-07)

You’ll have to try to do this by making a condition in your universe! I was thinking something like

(ADDRESS.COMPANYNAME = @prompt(‘Enter address (% for all)’,‘A’,‘Sales Calls\Companyname’,) AND @Prompt(‘Enter person (% for all)’,‘A’,‘Contacts\Name of Contact’,)=’%’) OR (@prompt(‘Enter address (% for all)’,‘A’,‘Sales Calls\Companyname’,)=’%’ AND PERSON.FREEFORMNAME = @Prompt(‘Enter person (% for all)’,‘A’,‘Contacts\Name of Contact’,))

But I guess this won’t work when you’re working with numbers…


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

Thanks jobjoris I will try it out.
Leo


Leo :us: (BOB member since 2004-01-07)

And for numeric values you could opt for TO_CHAR I guess…


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