Individual reports

The module for statistics and analysis based on the MS SQL Structured Query Language is a domain-specific language used in programming and designed for managing data held in a relational database management system, or for stream processing in a relational data stream management system. Reporting Services allows for the generation of miscellaneous report templates. The reports are available with filters, rendered according to the latest standards, and with functions like subscribe, drill down In information technology to drill down means to move from one place to another, information to detailed data by focusing in on something., image map In HTML and XHTML, an image map is a list of coordinates relating to a specific image, created in order to hyperlink areas of the image to different destinations (as opposed to a normal image link, in which the entire area of the image links to a single destination)., etc. in the formats JPG, TIFF, DOC, XLS, PDF, and HTML. Via the existing import interface, every individual report template can be created and imported easily and quickly with a respective designer.

For the generation of individual reports, a class library called ReportingHelper can be used. It offers various methods of formatting and communication.

These individual reports can be embedded via the Business Intelligence. RDL files can be uploaded onto the server and configured.

Visual Studio or another designer for RDL files (report definition files) is required in order to be able to create one’s own reports (see also MS Reporting Services).

In order to create reports for the Microsoft Reporting Services, basic knowledge on reporting is required.

The MS Reporting Services in the version 2005 SP2 or newer are supported.

 

Using the Reporting Helper Classes

A prerequisite for the use of the Reporting Helper classes is the embedding of the Reporting Helpers Code Library into the report properties.

Static Methods

Static methods of the Reporting Helper can be accessed as follows:

Methods from Instances

For non-static methods, an instance of the respective class has to be created:

Subsequently, the method can be accessed via the Code keyword:

 

Parameters

All of the reports accessed from the report stage have to contain the following parameters:

ClientObjectGuid: Passes all selected clients as a string separated by commas.

A ClientObjectGUID always has to be passed. For multiple-client-capable reports, multiple ClientObjectGUIDs can be passed.

LanguageObjectGuid: Passes the language of the current user and is used for the LanguageHelper and for the query of the LocalizedProperty table.

UserObjectGuid: Passes the UserObjectGUID of the current user and is used for permission queries.

Culture: Passes the specific culture of the current user and is used for localizations.

TimeZone: Passes the index of the time zone of the current user and is used for computing the date values. All of the date values in the database are specified in UTC Coordinated Universal Time (abbreviated to UTC) is the primary time standard by which the world regulates clocks and time. It is within about 1 second of mean solar time at 0° longitude, and is not adjusted for daylight saving time. In some countries where English is spoken, the term Greenwich Mean Time (GMT) is often used as a synonym for UTC. [Wikipedia] (GMT). They have to be converted via the time zone information first.

ReportName: Passes the localized name of the report defined and is displayed in the report’s title.

ReportDescription: Passes the localized description of the report defined and is displayed in the report’s description.