Error when use promptmany in Framework Manager

[khoinh]

Hi,

  I'm working with Cognos 8.4. I want to pass parameters from my report to defined store procedure. Because, I used multi-selected from report so that I used promptmany from macro in Framework Manager to do it. However, I get the error message:

QE-DEF-0406 Unknown function 'promptmany' in macro expression.

How can I resolve this issue? My data source is MS SQL 2005.

Thanks

[cognostechie]

I don't know what syntax you are using. I have this and it is working:

# promptmany('Pl. enter Date','Date''2010-01-01''','current_date')#

[khoinh]

Hi,

  My parameter from report is "my_selected". This is my syntax that I used in Framework Manager:
   #promptmany('my_selected','char')#

Thanks