Autherised Delear: ( May or maynot enter the value )
pay to party id: ( May or maynot enter the value )
Sub region: (May or maynot select the value from the list)
Country (May or maynot select the value from the list)
Meaning: this prompts can be required or not required condition.
i know it is not possible with prompts.
could you please help to how to solve.
if i want to use SDK’s, is there any license issue involved in it.
SDK’s and VB macros are one and the same.
I was also asked for the same question by some users. My suggestion was to get the users to agree on some default values for each of the prompts, and if the users do not select something else, the report would run on the default values only.
Let me know if you happen to get some better solution…
As you have found, it is not possible to leave a prompt empty. You can however, use some specific phrase (like ALL or ) and some clever SQL to simulate an optional prompt. Do a search here on BOB for the phrase "optional prompt" or similar. There are a couple of relevant posts at the top of this FAQ as well.
{note as moderator … I deleted your duplicate post in the BusObj Classic forum}
when i follow below code, it is prompting two prompts, i dont want two prompts at run time.
i want user to select All or single value or multiple value
ex:
SELECT DISTINCT
( ECH_ARCHIVE.REFCOUNTRY.COUNTRY_NAME )
FROM
ECH_ARCHIVE.REFCOUNTRY
WHERE
( (( ECH_ARCHIVE.REFCOUNTRY.COUNTRY_NAME ) IN @Prompt(‘Select Country Name
or
enter * for all groups’,‘a’,‘Region\Country Name’,multi,free)) and
(’*’ in @Prompt(‘Select Country Name or enter * for all groups’,‘a’,‘Region\Country Name’,multi,free))
)
(BOB member since 2005-09-21)
(BOB member since 2002-09-19)