Report Services

Here is the script I generated in class for creating a new report:

In the programs menu right click on Sql Server Business Intellegence services and start as adminstrator
Got to File/New project
Choose Business Intellegence Services
Report Service Project wizard
Name the project GrantsPerService, Next
In the Connection string dialog choose edit edit
type localhost for server/communityassist for database/windows authenication
Enter this SQL into the Query window:
Select ServiceName, MONTH(GrantDate) as [Month],
SUM(GrantAmount) as Total
From [Service] s
Inner join ServiceGrant sg
On s.ServiceKey=sg.ServiceKey
Group by ServiceName, Month(GrantDate)

Choose matrix for the report layout

Use month for column
servicename for row
total for detail

Choose you color

drag on pie chart from toolbox
service name for category
Total for data

Choose/build Deploy report

To view the report right click on the IE icon
Right click on Run as administrator
Type in the URL http://Itstudent-pc/reports
at home substitute your computer name for itcstudent-pc