How do i use the results from an sql query as the prompt input of my report?
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.