Value Prompt in Tabular SQL

[Kalyan cognoise]

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..........

[jayani]

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.