• 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 6 years, 8 months ago

 Assignment 7A - Reporting




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).




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




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.




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.