how to write ALL in macros

[kvchowdary]

I have arequirement like to consider 'ALL' in the prompt and same i am passing into DB.I have written the all like below:
and ( #prompt('pname', 'string', '1=1' , 'PRODUCT_NAME=')# or
#promptmany('PNAME', 'string', ' 1=1' , ' PRODUCT_NAME in (', 'pname', ' )')# )
I have used the html script to consider all,and created Static choice as 'ALL and default selection is 'ALL' in prompt page

It is not considering the ;ALL',but if i am selecting the any of the values it is considering and getting the report output,when i am selecting 'ALL' ,i am not getting anything?

help me on this

thanks

[BigChris]

Hi vck,

Are you running against relational data? Is this the same as the question you posted last week?

http://www.cognoise.com/index.php/topic,31902.0.html