SSRs
Use report Builder
And report Model
Create report Report builder is a simple GUI tool. You can use report builder to create the reports you need. After creating a report model and publishing it to the reporting services site, you can use report model and report builder to create a report. Although it is relatively simple to create a report using report builder, it may take some time to predict what reports users need and create a report model.
Shows the process of creating a report using the report model. First, the developer creates a report model, just like a blueprint. The data source is specified, indicating the data to be displayed. However, just as you cannot live in the drawing of a house, you cannot view the report through the report model. However, you can use report model and report builder to create your own report ). After a report is created using the report model, the report can also be published to the SSRs Report Server. First, use the SQL Server Reporting Services Configuration Manager to verify whether reporting services are installed and started. As shown in:
The SSRs report service is deployed in native mode by default. in SQL Server 2008, SSRs does not depend on IIS, and applications of reportserver cannot be found through IIS. Program Directory. The Web server URL of Reporting Services is http: // servername/reportserverreporting services. The report manager URL is http: // servername/reports. Report builder and report model are used to create a report, follow these steps: 1. use Business Intelligence Development Studio (bids) to create a report model project. 2. Add data source and Data Source view to the report model project. 3. Create a report model-Report Model in the report model project. As shown in, the employees. smdl report model has been created in this project. 4. Release the report model to the SQL Server Reporting Services Report Server.
If Microsoft. reportingservices. rsproxy. accessdeniedexception exception occurs during the release process, refer to the following Article : SQL Server 2008-SSRs report model released to Report Server this article provides the corresponding solution. 5. Visit the report manager site and start report builder. As shown in:
The model and data source directory are automatically created after the report model is successfully released to the Report Server in the previous step. Access the [model] Directory to view the employees report model successfully released in the previous step. 6. Use report builder on the report manager toolbar and create a report using the report model created in the previous step. After creating a report, publish it to the reporting service.
The following is a created report, as shown in:
For detailed operation steps, refer to the following article: 1. microsoft SQL Server 2008 all-in-one desk reference for Dummies, Book V-reporting services, Chapter 2-creating reports with report builder.2. SSRs Tutorial: SQL Server 2008 reporting services tutorialhttp: // www.accelebrate.com/ SQL _training/ssrs_2008_tutorial.htm