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
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 (http://www.cognoise.com/index.php/topic,31902.0.html)