How to filter report using macro based on selected option from query

[noirorekab]

i have a query that i want to use the selected option in this query based on a prompt to filter a report based on this selection, what can i do? i think it would be best to use a macro but what are the steps i would take to do this??