Using sql query list as prompt list

[joelyue]

How do i use the results from an sql query as the prompt input of my report?

[navissar]

Do you mean as selectable values? Make this query your prompt's query. When you drag a value prompt in, name the parameter then click next, create a filter if needed, do not define a new query. then highlight the value prompt, attach it to your query via properties and select the use value you want from the data items in that query.