Informatization infrastructure Reporting Services report development

Reporting Services

1. Design reports

2. Deployment reports

3. Test report

 

Design Report

Start Visual Studio 2008, create a report project, and add a new report.

Drag a table from the toolbox to the report designer

The report Properties dialog box is displayed automatically. Create a new connection and select. Net assembly as the type. The string is net. TCP: // localhost: 2908/servicemanager.

Return to report properties and prepare to enter an SQL query statement

Find the querybuilder component, open it, and select reportProgramSet. After clicking the method name under the type, the corresponding SQL query statement is automatically generated in the right pane.

If always copy to the clipboard has been checked, the query statement has been copied to the clipboard. In bids, click Query

The SQL query result is as follows:

Return to the report designer and assign values to the textbox of the table component. After the value is complete, the effect is as follows:

Add the date time, user ID, page, and report ID attributes to the report header, and set the table header font to bold.

Now, the report has been completed. Click Preview to view the effect.

Deployment report

Go back to the ERP application, open the report Manager Management Program, and select Add Report.

Select the report you just created and wait for it to be deployed to the server.

To maintain a unified user interface for reports, you can configure different report types, PASS Parameters automatically, and control permissions in the Report Dialog Box.

In the maintain Report Dialog Box, create a report id = glcucar and set the report type to reporting services. You do not need to add parameters and grant the execution permission to the function authorization.

Run the command in report Manager. The result is as follows:

In the report configuration program, configure the following report to browse the website

Click Connect to open and preview the report.

Report Test

1. precision. Different Rounding Methods and calculation methods affect the accuracy of the result.

For example, the result of grouping sum may be different from the result of summarizing sum, and the larger the data volume, the larger the error may be.

In addition, data precision loss occurs during each record calculation. For example, 100/1. 22 = 81.9672131147541, usually four decimal places are retained, and then this value is summed in sequence, and the result is somewhat different.

Again, math. roud () is not rounded down in the general sense, but internationally used.Algorithm. This will affect the value.

In SQL Server, round rounding is also somewhat different.

There are also differences between summary in the database and summary in the report.

2. All reports must have the same date format

3. Create a large amount of data to test the report performance.

For example, this tool is used to generate a large amount of data. The History Table in reportserver is used as an example.

The principle of the tool is to read the field type of the database table and generate a series of data into the corresponding column.

For numeric columns, you can use seed, auto-increment, or random Rand values.

Character columns can be used to add characters to numbers to generate different strings.

When the data size increases, the performance of the report will be significantly reduced. In this case, you need to find some optimization techniques.

4. Test the Selection Conditions

If you need to enter a value, it is best to provide a dialog box to select a value to reduce the number of errors or invalid values.

If it is time, you must control the value range based on the start time and end time of the business data.

5. data sorting requirements. The Group sorting and detailed data sorting rules must be unified.

6. font size, whether to add black, whether to tilt, all in accordance with the specifications.

The general rule is that the report title is 14pt, the report header is 12pt, the detailed data is 10pt, and the title is added to the blacklist.

7. Report export Test

Whether the exported format is unreasonable or whether it complies with the general paper size (A4) can be printed directly.

Whether the exported PDF file contains garbled characters and whether the page margins are reasonable.