SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

First of all, I must say that I'm new to this. I'm a 3rd year ICT & Business student and an intern in a international company. My assignment is to create a reporting service on the company's intranet (SharePoint).

The company wants to have a section on the intranet where only managers can access. To give you an idea, lets say one of the managers wants a report like this:

"Show the names of the male interns who worked between 2012 – 2013".

And lets say the interface on the intranet is going to be like the image below. enter image description here

Once the manager fills in the required fields and presses the button;

  1. SharePoint is going to create the query,
  2. SharePoint is going to ask for the data which is stored in the SQL Server,
  3. SQL Server is going to send the data to SharePoint,
  4. SharePoint is going to create an Excel File.

In order to achieve such a reporting system, where and how do you suggest me to start? Any links, guides etc. would be much appretiated. Even a general response would help me to understand the basics.

NOTE: Our IT department will handle the connections between the SharePoint and SQL server. I don't have to worry about that. All I need is to find out how you create a query on Sharepoint which will connect to SQL server and ask for data and display it on SharePoint (or Excel in this case).

Thanks in advance.

share|improve this question
If the data ends up in Excel, why route via SharePoint? Create a connection from Excel to the SQL source and create the user interface for it in Excel, too. No need to add another layer. You would need to use reporting services and other tools that are not easy to set up and may not be included in your license. SharePoint will not "create an Excel File", anyway. It might be the intermediary system but that would be wasting resources and time. A better, faster user interface can be developed by an Excel pro. – teylyn Mar 25 '13 at 11:22
Not every report is going to be in Excel. It was just an example. Some reports needs to displayed in SharePoint. – Axel Mar 25 '13 at 12:14

Reporting Services would probably be your best option given that the data is already in SQL Server. You can define parameters on the report so users filter what they see in the results and you can choose to output to Excel.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.