Steps to Create a Report with data model -- Sql server Reporting Service(SSRS)

To create a data model, follow these steps:

• If it's not already open, launch Business Intelligence Development Studio
• Select File > New > Project.
• Select the Business Intelligence Projects project type.
• Select the Report Model Project template.
• Name the new project AWSales and save it in a convenient location.
• Click OK.
• Right-click on Data Sources in Solution Explorer and select Add New Data Source.
• Read the first page of the Add New Data Source Wizard and click Next.
• Click New.
• In the Connection Manager dialog box connect to the AdventureWorks2008 database on your test server and click OK.
• Click Next.
• Name the new data source AdventureWorks and click Finish.
• Right-click on Data Source Views in Solution Explorer and select Add New Data Source View.
• Read the first page of the Add New Data Source View Wizard and click Next.
• Select the AdventureWorks data source and click Next.
• Select the Product(Production) table and click the > button to move it to the Included Objects listbox.
• Select the SalesOrderDetail(Sales) table and click the > button to move it to the Included Objects listbox.
• Click the Add Related Tables button.
• Click Next.
• Click Finish.
• Right-click on Report Models in Solution Explorer and select Add New Report Model.
• Read the first page of the Report Model Wizard and click Next.
• Select the Adventure Works2008 data source view and click Next. 

Keep the default rules selection, as shown below , and click Next.

 

      

• Choose the Update Statistics option and click Next.
• Click Run to complete the wizard.
•  Click Finish. If you get a warning that a file was modified outside the source editor, click Yes.
•  Select Build > Deploy AWSales to deploy the report model to the local Reporting Services server.