ReportServer BI Suite

ReportServer is the modern and versatile open source business intelligence (OSBI) platform for your company.

Read more or try it out

Open Source

ReportServer is open source software under the aGPL.

Independent

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.

Versatile

Pixel-perfect reporting, ad-hoc analyses, Excel and Word reporting or multidimensional OLAP analytics: ReportServer comes with a great selection of powerful tools.

Report Engines

ReportServer integrates the best reporting engines of different providers under a single user interface.
Always choose the right tool for your current task.

Eclipse BIRT

Pixel-perfect Reporting

 

Jasper Reports

Reporting ready for print

 

SAP Crystal Reports

Enterprise Reporting

Ad-Hoc Reporting

Self-Service BI

 

OLAP & Mondrian

Interactive, Multidimensional Analytics

 

Office Templates

Excel and Word Reporting

 

Script Reports

The Swiss Army Knife of Reporting

 

Try out ReportServer without any further delay.

Self-Service BI

ReportServer's Dynamic List is a powerful yet intuitive tool to create and manage ad-hoc analyses.

Dynamic Lists

  • Powerful tool for the ad-hoc generation of list-like reports
  • Supports various output formats from Microsoft Excel over PDF to XML
  • Comes with audit-proof documentation
  • Store your analysis as a report variant

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.

Powerful Filters

An effective ad-hoc reporting solution requires intuitive yet powerful filtering capabilities.

  • Configure filters per attribut
  • Inclusion-, exclusion- and range filters
  • Dynamic selections via wildcards and a date-API
  • Create arbitrarily nested filters with AND- and OR expressions
  • Intra-column comparisons

You can also employ statistic-arithmetic functions. Using these you are able to, for example, set specific conditions such as "the upper ten percent".

Aggregation

Using aggregation you can summarize even the largest datasets.

  • Aggregate your data
  • Create lists with intermediate sums (subtotals)
  • Use filters before or after aggregation

Column Formats

  • Configure the display format per attribute

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.

Templates

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.

  • Supports Microsoft Excel templates
  • Supports Microsoft Word templates
  • Create arbitrary XML dialects
  • Generate custom text documents

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.

Computed Attributs

Take advantage of the functionality of your underlying database for simple or complex computations.

  • Create new attributes via 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.

Self-Service Pivot

Discover new aspects about your data via ReportServer's Self-Service Pivot functionality.

  • Construct complex crosstabs
  • Visualize your data via various chart types

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 - Selected Highlights

Access Control, Security and Permissions

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.

ACLs and ACEs

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.

User Groups

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

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.

Authentication

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.

Scheduling

ReportServer comes with a dynamic scheduling component that allows you to execute reports at recurring intervals but also to, for example, run maintenance scripts.

The integrated time management enables you to schedule your reports in ReportServer and distribute them automatically, e.g., via email (and of course, emails can be sent encrypted if necessary). This also works for complex date patterns.
Define necessary conditions for a scheduled execution. For example, you can tell ReportServer to only send out quality management reports if cases actually exist.
ReportServer comes with a scripting language (Groovy) which can be used for various tasks. ReportServer's scheduler can be used to also schedule scripts, for example, a maintenance script that checks daily whether important reports run smoothly and which notify admins in case something is amiss.

Team-Ready with TeamSpaces

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.

Audit-Proof Metadata

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.

ReportServer is available in more than 20 languages*

  • Deutsch
  • Dansk
  • Eesti
  • Español
  • Français
  • Gaeilge
  • Hrvatski
  • Italiano
  • Latviešu
  • Lietuvių
  • Magyar
  • Malti
  • Nederlands
  • Polski
  • Português
  • Română
  • Slovenčina
  • Slovenščina
  • Suomi
  • Svenska
  • Čeština
  • Ελληνικά
  • Български

*Help us to create further translations or to improve existing translations.
We are looking to your support.

Extendable

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.

Administrative Scripts

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.

Script Reports

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.

Extensions

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

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.

And much more ...

  • Powerful Parameters
  • Entity Versioning
  • Import / Export
  • A large Number of Supported Datasources
  • Dynamic Script-based Datasources
  • Global Parameters
  • Easy Integrations
  • Report Configuration via URL
  • Interactive Reports
  • A Terminal for Administrators
  • Monitoring via JMX
  • ...

Flexible Parameters

Report designers can choose from a variety of parameters to allow for customization of reports.

ReportServer offers a wide range of flexible parameters to allow report customization. Report designers can choose from text-boxes, radio buttons, checkboxes, date parameters (besides being able to select a date from a dynamic calender date parameters allow users to select a date relative to the current day), popups and more.
Parameters work the same across all report types, that is, it doesn't matter whether you work with a Dynamic List, a Jasper report, a BIRT report or a Crystal report.
Parameters can be static or dynamic. For example, you can populate your selection list by using a database query.
When working with dynamic parameters you can have parameters depend on one another. For example, first select a country, and then select a city from a list of cities within the selected country.
Script parameters are the solution to any fancy requirement you might have. Are you asked to display a map in order to select a city instead of a simple list? With script parameters the UI is completely up to you.

Interactive Dashboards

Present all key performance indicators on a single page.

  • Unlimited dashboards per user
  • Freely configurable by the user
  • Integrate any report on your dashboard
  • Fast access via bookmarks
  • Integrate Micro-Apps via HTML5

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.

Download ReportServer today
and see for yourself.

Screenshots


Services

At datenwerke we provide support for all aspects of ReportServer,
and reporting and data processing in general.


Documentation

Our extensive documentation helps you to get started smoothly.

Read More

Enterprise-Grade Support

You require commercial support, a service level agreement with guaranteed response times or a managed release cycle?

Read More

Consulting Services

At datenwerke we offer consulting, training and development services for all stages of the analyzing process.

Go to datenwerke
ReportServer Services