What would you do to store your query in an SSRS report or a Database server?

These can be stored by using the storing procedure mentioned in the database server. The benefit of storing the query in this way is it stores the data in the compiled format and gives all the advantages of comparing it using Adhoc reports. However, the SQL queries can be stored directly in the text form, though this is not a good practice.