If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Pass parameter to Manual sql

Started by BIsrik, 19 Nov 2008 08:09:39 AM

Previous topic - Next topic

BIsrik

Hi,

How to pass parameter to select clause of manual sql.
I know how to pass in where clause.But when I am trying to put the same in select clause it is throwing error.

So that I want display dynamically the values from date in the report as column which comes through a select clause.

Thanks in Advance.

Suraj

#1
Select
from
where
column = #prompt('Prompt Name')#
-------------------------------------
Okay that was in where clause.
I have some reports that work fine in select clause as well.
What I have is this:
Select col1, col2,
decode(#prompt('Prompt Name')#,'AAA','Triple A','PRG','Progressive','Other') "Group"
from...
where...

and seems to work fine.

lindero

He wants to know how to use it in the select claude. 

Without trying, the following should work.

Select
   #prompt('param_name','token','{defaultcolumn}')# as columnA,
   columnB as columnB,
   columnC as columnC
from
   tableA
...