The requirement was to develop a chart via the application that shows task schedule of an employee and is also capable to measure the performance of an employee in number of hours worked per shift. This chart was put in the reporting services, reason being employees always get confused as to where to find a specific report, and the Report Server is preferred to organize vast amount of reports with different authorizations.
This application works on Reporting services. Here is how the process works.
An XML file is generated through dataset under .rdl file and saved in the server. Thereafter an xslt file is prepared, XSLT describes how the xml document should be displayed – XSLT is a stylesheet language for XML. The original document is not changed; rather a new document is created based on the content of an existing one. The new document may be serialized (output) by the processor in standard XML syntax or in another format – such as HTML or plain text. Xslt is most often used to convert data between different XML schemas or to convert XML data into HTML or XHTML documents for web pages, creating a dynamic web page. On report (RDL File) creates a link that follows us to the HTML page, basically SQL Server 2005 reporting Services (SSRS) is a server-based reporting platform that provides comprehensive reporting functionality for a variety of data sources. Reporting Services includes a complete set of tools to create, manage, and deliver reports. Reporting services tools work within the Microsoft Visual Studio environment and is fully integrated with SQL Server Tools and components. Once we are done with creating RDL File, we will need to deploy it on Report Server which manages all reports and information kept in reports on backend. Some of its tasks involve keeping metadata of reports, Data source information for reports and cached reports. All of this information is kept in SQL Server database which we will configure as part of configuring Reporting Services.
The reports developed and deployed on Report Server, is viewed by users using Report Manager, which uses report server on the backend.
About our Client
ASP.NET / VB .NET 2.0, MS SQL Server 2005, SQL Server 2005 Reporting Services, XML 1.0, XSLT 1.0