COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Kalyan cognoise on 27 Apr 2009 12:17:30 PM

Title: Value Prompt in Tabular SQL
Post by: Kalyan cognoise on 27 Apr 2009 12:17:30 PM
How will I create Value prompt in Tabular SQL......

I can able to create prompt in Tabular sql and I will used it as Text box , it is working.But my client requirement is like , he wants to select from the drop down.How can I create value prompt in Tabular SQL??

Anyone pls help me on this..........
Title: Re: Value Prompt in Tabular SQL
Post by: jayani on 27 Apr 2009 01:08:54 PM
Kalyan,

You can't create a value prompt within the SQL.
Instead use the same parameter which is used in SQL and create a value prompt.

Hope this will solve your issue of value prompt for the report with SQL query.


~ Jayani.