Opendoc - how to not pass a value to a optional prompt

building reports webintelligence
1

Hi Guys,

I have a report with two optional prompt. Those Prompt allow me to select a country and a type of customer for which I want to display data.
In some case I want data for all customer, therefore I don’t want to use the prompt.

When I use the opendoc function, if I put &lsSCountry=&lsSType= it gave no_value to the prompt and since there is no country and no type of customer name “no_value” I have nothing in my report.
and if I do not pass the lsSCountry and the lsSType parameter in the opendoc function, when the report open the prompt appear. But I don’t want it to apper I just want all the data. :hb:

Can anyone help me out.

Thx in advance. :mrgreen:

julien.alegre (BOB member since 2009-02-03)

2

Other people seem to have encountered the same issue, maybe a bug?

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

3

Well just stumble upon a post in another forum :

Fixed in 3.1 (don’t know which version)… but broken in 3.1 sp2 :crazy_face:

http://forums.sdn.sap.com/thread.jspa?threadID=1435210&tstart=15

eljuggy (BOB member since 2008-05-15)

4

Hi all!
The only way I found to solve that problem for ALPHANUMERIC type Prompts is to specify a LIKE test and pass a “*” or “%” instead of “no_value”.
Good work!

aangelo :it: (BOB member since 2002-09-28)