Print Page - Error when use promptmany in Framework Manager

Title: Error when use promptmany in Framework Manager
Post by: khoinh on 20 Sep 2010 04:40:37 AM

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

Title: Re: Error when use promptmany in Framework Manager
Post by: cognostechie on 20 Sep 2010 06:40:05 PM

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')#

Title: Re: Error when use promptmany in Framework Manager
Post by: khoinh on 20 Sep 2010 09:05:54 PM

Hi,

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

Thanks

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: khoinh on 20 Sep 2010 04:40:37 AM