COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: matteo on 26 Oct 2013 12:16:21 AM

Title: How to pass a Prompt Parameter to the SQL Query
Post by: matteo on 26 Oct 2013 12:16:21 AM
Good morning All,

I need to pass a parameter (inserted from the user in the Prompt page) to the SQL Query.

I do an example:

Parameter:
field1=?WORK_ORDER?

Query:
SELECT field1, field2
FROM MyTable
WHERE field1 =?WORK_ORDER?

Is this the right syntax???

Thanks so much.

Regards.

Matteo