SSRs uses report builder and report model to create a report

Source: Internet
Author: User
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

 

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.