| 
  • 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
 

COP4709A Assignment 7A - Reports

Page history last edited by Dr. Ron Eaglin 7 years, 2 months ago

 Assignment 7A - Reporting

 

Objectives

 

Create a database report (using Report Builder 3 ) - you may use Crystal Reports or another reporting tool ( the use of Visual Studio tools and/or Crystal Reports designer is not covered 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.

 

PLEASE NOTE YOU ARE DOING 2 REPORTS

 

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. This report will be a menu - the menu should have each Menu Group and under each menu group the Menu Items with Descriptions

 

Chili's To Go Menu

 

Appetizers

 

Triple Dipper™

Combine your 3 favorite appetizers!
Served with dipping sauces.
• Big Mouth® Bites
• Boneless Buffalo Wings
• Boneless Honey-Chipotle Wings
• Southwestern Eggrolls
• Original Chicken Crispers®
• Loaded Potato Skins
• Hot Spinach & Artichoke Dip

 

California Grilled Chicken Flatbread

Topped with grilled chicken, applewood smoked bacon, tomato sauce, Monterey Jack, mozzarella, chopped cilantro, house-made pico de gallo, fresh sliced avocado & a drizzle of roasted garlic aioli.

 

Soup, Chili, and Sides

 

Southwest Chicken Soup

Oven-roasted chicken, hominy & tomato in a flavorful ancho-chile chicken broth. Topped with crispy tortilla strips & chopped cilantro.

 

Chicken Enchilada Soup

Topped with crispy tortilla strips & 3-cheese blend.

 

 

 

 

 

Include a screen capture of your final report. You should have at least 2 menu groups with at least 2 items in each to demonstrate the report.

 

Note: As with all assignments - these examples are provided for your convenience. You can demonstrate proficiency of using reporting tools using any databases that you are using for your own projects.

 

Information

 

About SQL Server Report Builder - https://msdn.microsoft.com/en-us/library/dd220460.aspx 

 

About Visual Studio Report Designer - https://msdn.microsoft.com/en-us/library/bb558708.aspx 

 

List of top reporting softwares - http://www.capterra.com/sem-compare/reporting-software 

 

Estimated Completion Time

 

Allot at least 10 hours to this assignment. You may want to start early. Once you complete these you should have enough expertise using a report building software to produce relatively complex reports.

 

Supporting Lectures 

 

Topic - Creating Reports

 

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 

Creating a Stepped Report with Report Builder -   https://msdn.microsoft.com/en-us/library/dd220467.aspx

 

 

 

Grading Criteria

 

5 points for report 1

5 points for report 2

Comments (0)

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