Application of Reporting Service in Web Application

Since Microsoft's report services is used as a report output tool in this project, I have also studied it a little bit, however, this knowledge can at least be applied in most reporting service scenarios.

It was a bit mysterious when we installed the Reporting Service. After all, we didn't really come into contact with this Microsoft report tool to replace the crystal report before doing this project, moreover, Microsoft does not seem to be satisfied with the simplicity of a report tool.

Reporting Services is a new server-based report platform, which is deployed on Microsoft SQL Server 2000, you can create and manage table reports, matrix reports, graphical reports, and free-format reports that contain data from Relational Data sources and multidimensional data sources. You can view and manage your reports through a web-based connection.

Reporting Services provides a complete set of services, tools, and application programming APIs. You can use reporting services even if you are not a programmer. You can use applications and tools included in reporting services to create, publish, and manage reports. In addition, tools or applications supporting various stages of the report lifecycle are provided. Programmers can use APIs to extend or integrate the report functions into custom solutions.

This article mainly introduces some of the technologies involved in the development of reporting service. First, we can see from its service that it provides the Web service interface, and allow us to embed code in the report (must be VB.. Net), you can also reference.. NET Framework.

This article focuses on two aspects of the reporting service development technology.
1. Integrate the report service provided by reporting service in a custom application
Generate Report presentation component

To integrate the report (RDL file) of the reporting service into a custom application, we can use a report display component that comes with the reporting service, it can be obtained by compiling the reportviewer of the sample project. The default value is reportviewer. DLL.
By compiling the reportviewer of the sample project, we can use the components used to integrate the RDL file in a custom application. However, if we need to pass parameters to the report in a custom application, reportviewer compiled by default. the DLL component is not supported. Next, we need to solve this problem. How can we assign values to report parameters in custom applications?

 private void SetParameter(string name, string value){……}

The function of this method is to set values for the report parameters, so you may be very happy, because it provides a method for support, but when we see private, we may not be happy. Microsoft's basic security considerations do not expose the method for passing parameters by default. However, applications and security are mutually exclusive.

Now we know at least how to extend this function to achieve our goal.

 public void SetQueryParameter(string Name, string value){this.SetParameter(Name, value);}

Let's add a public method setqueryparameter. Re-compile the component, and the component has the parameter passing function.