Hi Gurus,
I have a date filter to select the date( parameter is pdate). so earlier in my query it is ( date >= ?pdate?)
Now i have to provide an option to select the operation at run time like <,>,=..etc.....
for that i took a value prompt(parameter is pch) next to date prompt with static choices(<,>,=..).
Now how to put this selected value in the query?
dont know is it possible or not... i just tried in this way. suggest me if any other way.
thanks in adv.
substitute and prompt macros
http://cognosknowhow.blogspot.fr/2012/06/how-to-achieve-dynamic-operator-using.html
The macro in that example is needlessly complicated. There's no need for the substitution function, just put the prompt for the operator before the prompt for the value:
[Namespace].[Table].[Date] #prompt('pch','token')# #prompt('pdate','date')#
ThanQ Paul & LDJ for ur reply.
i have put this one in query, but getting error.
[Namespace].
.[Date] #prompt('pch','token')# #prompt('pdate','date')#.
do i need to set any properties for my parameter pch???
thanks in adv
|
There are millions of possible errors or warnings you might be receiving. Without seeing the error, there is very little I can do to help. Post the entirety of the error.