I have a standard report in which contains 3 prompts. A user should be able to specify only one of them and leave all other blank. The where clause should contain only the columns for which a prompt was filled.
Is there anyone who has done this before? Regards, Michiel Brunt
ABN AMRO Bank
For example:
Prompt variables:
YEAR OFFICE_NO CUST_NO Where clause:
1998 year=1998
1998 1234 year=1998 and office_no=1234
1234 4567 office_no=1234 and cust_no=4567
I have a standard report in which contains 3 prompts. A user should be able to specify only one of them and leave all other blank. The where clause should contain only the columns for which a prompt was filled.
Scripting would be one alternative.
However, I would love to see an “OPTIONAL” parameter for @PROMPT/@VARIABLE, built into the product.
-Chander Aggarwal
COMPUEXCEL http://www.compuexcel.com
The home of BusinessObjects Essentials - the Worlds First and Leading Full Multimedia Computer Based Training For BusinessObjects, with over 10,000 users world-wide!
I have a standard report in which contains 3 prompts. A user should be able to specify only one of them and leave all other blank. The where clause should contain only the columns for which a prompt was filled.
Is there anyone who has done this before? Regards, Michiel Brunt
ABN AMRO Bank
For example:
Prompt variables:
YEAR OFFICE_NO CUST_NO Where clause:
1998 year=1998
1998 1234 year=1998 and office_no=1234
1234 4567 office_no=1234 and cust_no=4567
Michiel,
Search the archives of the list. There was a string of messages about 2 months ago talking about optional document prompts. Erich Hurst gave a suggestion for a way to do this. I also had an idea that built off of this.
Glenn Fredericks
Data Warehouse Specialist glenn_fredericks@aal.org
(920) 730-4700 x4236 or 1-800 CALL AAL
Aid Association for Lutherans
4321 N. Ballard Road
Appleton, WI 54919-0001
Visit our Web site at www.aal.org or e-mail us at aalmail@aal.org
AAL… Financial services. Lutheran heritage. A powerful combination.
We have achieved this via scripting. We offer up a dialog box with the choice of the 3 prompts. Depending on which checkbox is checked we then add the corresponding condition to the query. The conditions are pre-defined in the universe and allow the users to select from the relevant list of values.
I hope this is clear enough.
Chris Timm
BP Gas Marketing.
London, UK.
Michiel wrote:
I have a standard report in which contains 3 prompts. A user should be able to specify only one of them and leave all other blank. The where clause should contain only the columns for which a prompt was filled.
There was a post on this a while back.
The work-around did not help in leaving the prompt empty, but when you train the users to type in ‘all’ instead of leaving the prompts blank you could use it to give the functionality they want.
Create a filter that says:
Where @Prompt(…) = OR @Prompt(…)=‘all’ (Sorry, I didn’t bother to spell out the prompt syntax.)