Simple SSRS report

J G
J G used Ask the Experts™
on
SSRS Report

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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Business Intelligence Developer and Analyst
Top Expert 2015
Commented:
You can create SSRS report using SSDT ( Sql server Development Studio).

Below is the link "https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt"

Steps are as below.

1) Create stored procedure for the same. This stored procedure will have parameters, what ever filter you want to have in Reports.
2) One you are done with your stored procedure parameter decision. You can write procedure logic. Compile your stored procedure and try to give a successful run by passing parameter in stored procesure.
3) Once you are done and satisfied with your procedure result.
4) Create report in ssdt, create appropriate parameter in report.
5) Put your stored procedure in data set refresh fields and map parameter.

You can check below post to start with Report development. It might help you.
Below is link.
First SSRS Report
Arifhusen AnsariBusiness Intelligence Developer and Analyst
Top Expert 2015

Commented:
There is not other comment for the solution. Comment that has been shared help resource to Get starting with SSRS reports.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial