| 
  • If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • You already know Dokkio is an AI-powered assistant to organize & manage your digital files & messages. Very soon, Dokkio will support Outlook as well as One Drive. Check it out today!

View
 

Spring 2012 Assignment 6 - Creating a Report

Page history last edited by Dr. Ron Eaglin 12 years, 3 months ago

Spring 2012 Assignment 6 - Creating a Report

 

Objective

 

Learn how to write reports using the report builder tool

 

Assignment

 

1. There is a live tutorial (you make a real report) at this link https://cmg.vlabcenter.com/default.aspx?moduleid=161829fc-ecdd-4011-89e6-878d9ce933df  (you can access a list of ALL live tutorials at http://msdn.microsoft.com/en-us/sqlserver/cc138238.aspx )

 

You will do the entire tutorial for Building and Sharing Your First Report Builder 3.0 report. This is a reporting tool, and is a good example of a reporting tool and how you get it to interact with a database. In the tutorial, the you will use the Adventure Works database. This is already set up for you, but you do run a script to make it accessible to the tools you are using.

 

While you do this tutorial make sure you understand what you are doing (and if you don't post to the bulletin board). This will be important because the assignment does not have a guide for you to follow.

 

2. You have these same tools available to you in SQL Server. You are now going to create your own report using your own database. This report is simple - you will create a course schedule report that allows you to see a nice version of the courses a student is taking for a given semester. You will use your database from the previous assignment creating a course scheduling database ( Spring 2012 Assignment 4 - Starting with Stored Procedures ).

 

The report will show the current schedule for a student for a given semester. You may want to create either views or stored procedures that will return this information - this will make the report generation much easier.

 

You may want to add both fields to your database design and you will definitely need to add data to your tables to test this out. If anyone has created an insert script for these please feel free to share on the bulletin board.

 

Resources

 

Professor Video of getting started - http://online1.daytonastate.edu/player2.php?id=a3eb043e7bf775de87763e9f8121c953

 

Report Builder Download Page - http://www.microsoft.com/download/en/details.aspx?id=6116 

 

Report Builder  Getting Started Page - http://technet.microsoft.com/en-us/ff657833.aspx 

 

 

 

 

 

Comments (0)

You don't have permission to comment on this page.