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.
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!
California Grilled Chicken FlatbreadTopped 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 SidesSouthwest Chicken SoupOven-roasted chicken, hominy & tomato in a flavorful ancho-chile chicken broth. Topped with crispy tortilla strips & chopped cilantro.
Chicken Enchilada SoupTopped 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
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.
Getting Started with Report Builder 3
Lecture - Report Builder Part 2
Lecture - Report Builder Part 3
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
5 points for report 1
5 points for report 2