Microsoft SQL Server 2000 Reporting Services Introduction (4)
[Abstract] This article analyzes some of the less common functions of Reporting Services, and finally lists some of the shortcomings of Reporting Services based on the usage, and it is estimated that these shortcomings will be solved in the official version.
[Key] Reporting Services, .NET Framework. Drillth, RDL file, RDS file
N rdl file elements
In the previous article, it is simple to analyze the RDL file, in fact, to complete a report, there are many information, simple example below
The action of Action data is mainly to achieve links
AllowBLANK specifies if the parameter is allowed to be empty
Author report
Bookmark images, reports can be added to Bookmark
N rs script interpreter
A scripting interpreter RS.exe is also provided in the Reporting Service package. Enter rs. In the command line. VB.NET specification, in the .RSS script file, a global variable RS can be used directly, where the RS variable here corresponds to the current REPORT Server, and the usage method can learn from the two reference files:
CancelrunningJobs function is to cancel the running report job
The PublishSampleReports function is to publish all examples in Samples to Report.
On Server and is uniformly placed in the Sample Reports folder.
Two examples can run with the following command, where MyServer wants to modify to report servers.
Address, you must ensure that the location of the command line is correct.
1. RS -I PublishsampleReports.rss -s http: // myserver / reportserver -v parentFolder = "Sample Reports"
1. rs -i canrunningjobs.rss -s http: // myserver / reportserver
The common methods of RS are:
Listjob
Caceljob
CreateReport
CreateFolder
CeratedataSource
The above methods can be found in two reference examples.
Some shortcomings in N Reporting Services
Because the Reporting Services now used is the beta version, it is still easy to find a lot of problems when used.
The example given in the help seems to be running, for example
