Is it possible to create prompt in prompt page in sql based report

[inu]

Hi Team,

As I am developing one sql based report, because in the package reuired table is not available. And i need to create a prompt as select and search prompt.. i used macro prompt in sql query as jc.jc_job_reference in (#promptmany('param1')#)
and pulled select and search prompt into prompt page. when i search for any value, it keeps searching only and finally doesnot give any value to be inserted.

Please suggest me in this regard.
Thanks in advance

Regards
Inam

[cognos810]

Hello inu,
What is the source for the search and select prompt. You did not mention, if you created a separate query to be used as the "Use value" for the search and select prompt. If not, please do so. From looking at your example, you may need another query with one column that gives you a list of values for jc_job_reference. Then use that column as the Use value for the search and select prompt.

If the DB objects you need is not available in your package, you can ask your FM modeler to build one for you. Either incorporate it in the same package or give it to you in a separate package. That would be the best and recommended route to take.

-Cognos810