Fields in the query and the framework

Assignment Help Business Management
Reference no: EM131291549


Assignment Overview

Using the classroom discussions last week and the knowledge you gained from last week's assignment, list the AdventureWorks most profitable products in a report, not a query. A product's Total Profit is calculated as the Total Sales for the product minus the Total Cost of those sales. Total Profit, Total Cost, and Total Sales are not fields in a table they must be calculated in your SQL statement. In this assignment you will print the relevant ERD, the SQL query, and the Report results to PDF files and submit the PDF files to this assignment in Blackboard. You will need to figure out which tables and fields you need to answer create the report. You will need to design the query that provides the required information, and you will need to create and execute the report that shows Product Number, Quantity Ordered, Total Sales, Total Cost, and Total Profit, sorted in descending order by Total Profit. You will only need to print the first five pages of your report to a PDF file.


1. After opening SQL Server, go to the AdventureWorks database in the left pane, expand the database, right click on database diagrams, click new database diagrams, and explore the ERD for AdventureWorks until you can identify the tables necessary to develop the query.

2. Right click on AdventureWorks database in the left pane, click new query, then in the new blank window right click and select Design Query in Editor. When the list of tables pop's up, and select the tables required to design the correct query.

3. Choose the fields necessary to create the query.

4. Once you have the fields in the query and the framework has been created by query designer (previous steps), modify the query to create the required calculated fields, add the grouping, and the sorting statements.

5. Open SQL Server Data Tools, click File, New, and Project. Then select Report Server Project Wizard, type a report name, and click OK.

6. Start the wizard, connect to the server and the AdventureWorks database, then go back to SQL Server and copy the query that you have already gotten to work and paste it into the query string box. Continue the wizard, selecting report options, and including all required fields on the report. After completion, press preview to see the results are as you expect.

7. Go then to the report design tab and add a heading "AdventureWorks Most Profitable Products" and also add a report footer including "Page n of m" where n is the current page number and m is the total pages.

8. Print the ERD, Query, and Results each to a PDF file that you submit on Blackboard.

Reference no: EM131291549

Differences between a separation of duties and job rotation

Explain the differences between a separation of duties and job rotation. Why is separation of duties important? Why would you do job rotation? What is the purpose of each?

Private industry surveillance of private citizens

Since there are few legal limitations on private industry surveillance of private citizens, could the government contract surveillance to private companies? Would this be le

Problem regarding the network security

As a corporatenetwork administratorthe industry standard suggests your job is to maintain the confidentiality, availability, and integrity of all network resources. Choose a

Identifying the root cause of the non standard time

Identifying the root cause of the non standard time based on the reports below * Analyses (graphical and cost) showing where the problem is coming from based on the reports.

Problem regarding the connectivity troubleshooting

The desktop administrator at a remote satellite office called you to let you know that one of their users is having connectivity problems. Based on what you've learned this

Security plan-what employees need to know

After the SAP has been designed, it is time to develop all the supporting materials needed for a successful execution of the plan. During the development phase, it is not on

Retail chain to produce documents

You have been asked to audit a national retail chain. Select one access device and one instance of application software which could be used by the retail chain to produce do

Examples of application software commonly

Choose five examples of application software commonly used within organisations. Write a report in which you provide details of the main features of each program which you


Write a Review

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd