SQL Reporting Services

These two days I have tried SQL reporting services and compared it with the Help file for a simple project. I feel that this tool is easier to use than the Crystal Report (probably because it is not in-depth ), here I wrote some basic steps and related operations for the Development Report Project (relatively simple). I hope to share it with you. I also uploaded two images to view the report interface, strong functions!

1. Report Generation
1) create a project in vs.net: choose Business Intelligence> report project.
2) Add a shared data source with the suffix "RDS.
3) Add a report with the suffix ". RDL.
4) create a new dataset and enter the data view, which is similar to the data view of sqlserver. You can add tables and filter fields.
5) enter the design view, drag the table from the toolbox, and drag the fields to be displayed to the detailed information of the table in the "field" toolbar. Set the table header as needed.
6) preview the view.
7) Grouping: Click table in the design view, insert a group, and drag the group field. Multiple groups are supported.
8) perform the summary operation: drag the fields to be summarized to the end of the table in the design view.
9) Add a footer: Right-click the footer in the design view, drag the text box from the toolbox, right-click the expression, and select pagenumber in "Global.
10) Add a chart: In the design view, add a row to the table and drag the chart control to set the data fields and category fields to be displayed. To change the icon format, right-click charttype.
11) Document map: In the design view, edit the group attribute and set the document map label.
12) dynamic query: In the design view, select "report" in the toolbar, select report parameters, add parameters, and set them.

2. Report management mainly refers to the Report Server.

3. Click project properties in vs.net to publish a report, and set targetserverurl to http: // servername/reportserver.