Print Page - using parameters in query

Title: using parameters in query
Post by: morphy on 10 Nov 2008 04:07:29 AM

Hi All,

a simple question 4 u.

Is it possible to insert a parameter in the query?

Example:

select evt_code, evt_org from EVENTS
where evt_org =?org?

Where ?org? is a parameter previously created in order to let the customer
choose the organization.

Thanks in advance.
Matt

Title: Re: using parameters in query
Post by: Suraj on 10 Nov 2008 09:08:12 AM

yes;but only one data item for one condition at a time...

if (evt_org = ?org?) then (evt_code)
else null

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: morphy on 10 Nov 2008 04:07:29 AM