ReportServer is open source software under the aGPL.
The integration of reporting engines from several companies within a single application gives you the flexibility to always choose the right tool for the current task.
Pixel-perfect reporting, ad-hoc analyses, Excel and Word reporting or multidimensional OLAP analytics: ReportServer comes with a great selection of powerful tools.
ReportServer integrates the best reporting engines of different providers under a single user interface.
Always choose the right tool for your current task.
Reporting ready for print
Interactive, Multidimensional Analytics
Excel and Word Reporting
The Swiss Army Knife of Reporting
ReportServer's Dynamic List is a powerful yet intuitive tool to create and manage ad-hoc analyses.
The Dynamic List is the preferred method in ReportServer for fast and user specific analyses of data.
The real data (i.e., the raw data) for your reports is usually stored within in tables (aka. lists). With ReportServer's Dynamic List you can directly access this data and compile and configure it in various different ways. Dynamic Lists can be used for individual data processing (e.g. with Microsoft Excel) or converted to various output formats (e.g. XML, CSV, PDF). By employing Templates you can also load specific data directly from your dynamic lists into predefined Excel or Word documents. This way many steps of individual data processing become redundant.
From the simple selection of data by column selection and filters, via sorting, grouping or sub totals through to complex analytic functions - nearly every analysis request can be carried out by the Dynamic List.
Once configured, analyses may be stored as so-called report variants which can then be scheduled to be executed at recurring intervals (and, for example, delivered via email), shared with your colleagues and further utilized within the TeamSpace.
An effective ad-hoc reporting solution requires intuitive yet powerful filtering capabilities.
You can also employ statistic-arithmetic functions. Using these you are able to, for example, set specific conditions such as "the upper ten percent".
Using aggregation you can summarize even the largest datasets.
The display format (e.g., currency, number, date) can be configured per attribute which makes manual adjustments after exporting the report (e.g., to Excel) superfluous.
With templates you can load data from a dynamic list directly into a preprepared office document (Microsoft Excel or Word) or into an XML or text format.
ReportServer supports various templating engines which can be combined with the Dynamic List. Via JXLS you can prepare templates in Microsoft Excel and embed data from your report. Similarly, you can use Microsoft Word documents as templates (for this ReportServer integrates the excellent xdoc templating language).
On top, you can use XSL and Velocity templates to generate any form of XML or text format.
Take advantage of the functionality of your underlying database for simple or complex computations.
Computed attributes provide access to the functionality of the underlying database which allows you to easily perform simple or even very complex computations. For example, you can easily perform arithmetic computations and add up attributes. But it doesn't stop at arithmetics: you can use CASE constructs to cluster data or use string functions or even analytic functions.
Are you worried about security? Don't be. It is easy to restrict the functionality and to allow only what you want to allow.
Discover new aspects about your data via ReportServer's Self-Service Pivot functionality.
Pivot tables allow you to visualize even very large datasets along different dimensions in a concise way. Via ReportServer's unique Self-Service Pivot capabilities you can now transform your dynamic lists into Pivot reports and visualize your data in crosstabs or as charts.
ReportServer is ready to be employed in large companies and displays even complex authorization models in a manageable way. All objects are stored in hierarchical structures. This enables you to efficiently assign rights for entire sub trees.
The authorization follows the standards of ACLs and ACEs. There is a list of permission entries for any object that needs to be saved. The permission entries control the access both to the object itself as well as to all its sub objects. This empowers you to comprehensibly and efficiently organize authorization even in huge structures.
To create authorizations that do not result from the user's position in the tree, it is possible to define user groups. In these groups single user, folders and entire sub trees can be subsumed and authorized. Therefore even access privileges that break the hierarchy can easily be implemented.
User variables take up a specific role in ReportServer. They facilitate a line-by-line authorization solution right up to the reports. The value of a user variable is defined by the user’s position in the hierarchy. The inheritance mechanism simplifies the administration complexity. The value of the user variables can now be requested at the time of a report’s execution and may be used for a limitation of the returned data.
You are running an Active Directory, or want to integrate ReportServer into a Single-Sign-On Solution? ReportServer is ready to be deployed within your IT-infrastructure. ReportServer is versatile and extendable and allows you to hook into its authentication process to extend it via scripts or to even replace it completely with your preferred solution.
ReportServer comes with a dynamic scheduling component that allows you to execute reports at recurring intervals but also to, for example, run maintenance scripts.
Today, mostly all working fields of a company are organized in teams. To reflect this structure also in the reporting platform, ReportServer has developed and introduced the concept of TeamSpaces. TeamSpaces derived from the experience that shared resources, i.e. network drives, always entail a high-maintenance.
The challenge with teams: Everyone needs to be able to access and work with the available data. Additionally, several user groups need different displays and structures of the same objects. An administrator in example might prefer a display organized according to the data origin, whereas for the end user an organization according to the intended application purpose might be more rewarding. Still the existence of numerous report versions needs to be avoided: otherwise in the end no one will know which the correct version is. TeamSpaces explicitly tackles this problem.
All report objects in ReportServer reside in a single tree hierarchy that can only be edited by administrators. TeamSpaces now enables users to define their own display of the report tree. This can be done by importing objects, either from the global catalogue or from other users’ TeamSpaces, and storing them structured according to their own needs.
To foster team cooperation, members of one TeamSpace can edit the contained objects together. The special feature: Changes done by one user are immediately available to all others. TeamSpaces also has a simple, role based rights management that can be administered by the users themselves and therefore easily allows a cross-team sharing of results.
ReportServer prepares detailed documentation for every report. This includes all user defined configuration such as the selection of parameter values. On top, for dynamic lists, the documentation lists every selected attribute, filter, format, computed column etc.
ReportServer's automatic documentation is an audit-proof documentation explaining the origin of your data.
And as almost anything within ReportServer. If it is not yet sufficient, it can be easily extended to suit your needs.
*Help us to create further translations or to improve existing translations.
We are looking to your support.
A special function of ReportServer is that it can be extended by the means of scripts. Scripts help you to accomplish various tasks faster and more efficient. Lighten your workload by automating recurring tasks or developing individually adapted functions.
Administrators know: the service and maintenance of a reporting platform is a time consuming task. The script engine integrated in ReportServer provides you with full access to the object model as well as the service infrastructure of ReportServer. This gives a powerful tool for the automation of maintenance tasks.
Scripts can be used for the definition of entire reports providing you with the most flexible way to create reports yet. You want to join data from different sources or you need special output formats? Scripts offer wide-ranging possibilities from interactive reports to the generation of specialized output formats. And best of all, once you learn your way around scripting, script reports are easier to maintain and fast to set up.
Scripts allow you to implement customer specific enhancements without having to change ReportServer code or compiling ReportServer from scratch, thus, greatly minimizing the risk of incompatibilities with future versions.
There is a wide spectrum of possible extensions. From displaying additional information to the development of completely new modules: there are various ways to adjust ReportServer to fit your needs.
Script datasources can be regarded as a special form of script reports. Therefore the wide ranging possibilities of the scripting engine for accessing and manipulating data are at your disposal. Subsequently, you can use the outcome as basis for reports or parameters.
Report designers can choose from a variety of parameters to allow for customization of reports.
Present all key performance indicators on a single page.
ReportServer dashboards can be easily integrated into third-party applications using iFrames. This allows you to, for example, add reporting capabilities to your products or present data and reports in a portal or web app.
At datenwerke we provide support for all aspects of ReportServer,
and reporting and data processing in general.
Our extensive documentation helps you to get started smoothly.Read More
You require commercial support, a service level agreement with guaranteed response times or a managed release cycle?Read More
At datenwerke we offer consulting, training and development services for all stages of the analyzing process.Go to datenwerke