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.
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.
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
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…