sql server - Displaying Reports on SharePoint -

first of all, must i'm new this. i'm 3rd year ict & business student , intern in international company. assignment create reporting service on company's intranet (sharepoint).

the company wants have section on intranet managers can access. give idea, lets 1 of managers wants report this:

"show names of male interns worked between 2012 – 2013".

and lets interface on intranet going image below.

http://i.imgur.com/ebzxp8t.jpg

once manager fills in required fields , presses button; 1.sharepoint going create query, 2.sharepoint going ask data stored in sql server, 3.sql server going send data sharepoint, 4.sharepoint going create excel file.

in order achieve such reporting system, , how suggest me start? links, guides etc. appretiated. general response me understand basics.

note: our department handle connections between sharepoint , sql server. don't have worry that. need find out how create query on sharepoint connect sql server , ask data , display on sharepoint (or excel in case).

thanks in advance.

if you're not already, need use sharepoint designer. create new site in sharepoint. you'll need manage permissions prevent non-management accessing new site. open new site in sp designer. bring data source library (data view > manage data sources). there can 'connect database...'. can't there. you'll need db connection string , you'll have design query gets super set of interns (to example). can use filters extract specific intern. take exploring on part. may able customize sql query using form elements haven't seen done before. typically db connection pulls down data table , consumed web parts on page.

hope @ least gets started...