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!

COP4709A Assignment 7A - Reports

Page history last edited by Dr. Ron Eaglin 7 years, 7 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.