Assignment 7 - Reporting

Objectives

Create a database report (using Report Builder 3 ) - you may optionally use Crystal Reports, however the use of Visual Studio tools and/or Crystal Reports designer is beyond the scope of this course.

Assignment

For this assignment you are going to create a report using Report Builder. The current version is 3.0 and it is a download that is available at http://www.microsoft.com/en-us/download/details.aspx?id=6116 - this tool is like most report builders (like Crystal Reports) - but it is free and it works well with SQL Server so we will use it.

Part 1 -

Part 1 will allow you to practice with Report Builder and is worth 50% of the assignment. For part 1 use the data provided at the lecture site - Getting Started with Report Builder 3 and create a simple report of Fiscal Year in the LEFT column, Continent in the TOP row and the sum of all financial aid in the report cells. This should be straighforward as what you are doing will follow the lecture on Report Builder.

You will turn in a simple screen capture of your formatted report.

Part 2 -

This report will be more challenging. You will be creating a report that looks like this using Report Builder (this is a sample with 2 menu groups  and multiple items).

Menu: Chili's To Go Menu

Information

Estimated Completion Time

Allot at least 10 hours to this assignment. You may want to start early.

Supporting Lectures 

Getting Started with Report Builder 3

Lecture - Report Builder Part 2

Lecture - Report Builder Part 3

Questions and Answers

External Resources

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

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

Crystal Reports for Visual Studio Download Page - http://www54.sap.com/solutions/sme/software/analytics/crystal-visual-studio/index.html 

Grading Criteria

5 points for report 1

5 points for report 2