I have written a query to pull a basic "Item File" report from my companies master database. 10 columns, 65k rows.
Instead of just creating an Agent job-->export to CSV, I would like to post the results of my query on our SSRS server to view with parameter Drop-downs to filter on 3 or 4 or the fields.
Could someone give me basic instructions of how to do this? Since it is just 1 report, I believe the data source should be embedded. We have a report server with SSRS services running.