Creating the Employee_Sales_Summary_2008R2 Report (SSRS)

This tutorial helps you build the Employee_Sales_Summary_2008R2 report from the suite of AdventureWorks 2008R2 sample reports. The Employee_Sales_Summary_2008R2 report answers the following questions for salesperson who sells products for the AdventureWorks Cycles company:

  • How do my seasonal sales compare year over year?

  • How do the category sales for this month compare to sales for the same month in previous years?

  • Am I meeting my sales quotas for the whole month and for each category?

For more information about the suite of reports and their relationships, see Tutorials: Creating AdventureWorks 2008R2 Sample Reports (SSRS).


For the list of requirements, see Prerequisites for AdventureWorks 2008R2 Sample Reports (SSRS).

This tutorial assumes that you have completed Creating the Report Server Project and the AdventureWorks2008R2_Base Report (SSRS).

Next Steps

To build other AdventureWorks sample reports, see Tutorials: Creating AdventureWorks 2008R2 Sample Reports (SSRS).

Change History

Updated content

  • Changed report suite to include AdventureWorks2008R2_Base.rdl