I´m trying use a @Ptompt in a WebI report, but the users wants select one or more values in prompt, but sometimes they need select no one value.
But, when leave the prompt in blank, the “execute” button is disabled.
EX.:
upper(dbo.f_dviagemRPT.EMPRESA_COTACAO) In @prompt(‘Enter value(s) for Empresa Aerea:’,‘A’,‘Filtro processo\Empresa Aerea’,Multi,Free,Persistent,User:1) with various values…
upper(dbo.f_dviagemRPT.EMPRESA_COTACAO) In @prompt(‘Enter value(s) for Empresa Aerea:’,‘A’,‘Filtro processo\Empresa Aerea’,Multi,Free,Persistent,User:1) with no values
Which BO version do you use? There are optional prompts in BO XI 3.
If you use lower version then explore the “ALL in LOV” concept. In few words, not entering any value in a prompt is the same as using the value ALL which is transformed behind the scenes into a condition that is always true (ALL=ALL):