ReportServer - An Introduction

The organizational chart of our fictional enterprise is also based on the Eclipse sample data. On this basis we have introduced departments and divisions each with access to reports regarding their area of work. In the course of this introduction we will assume the position of different users to introduce the various aspects of ReportServer.

To start, we want to show you how ReportServer looks from the point of view of a typical user. For this please go to login page and login with the following credentials:

username: gbondur
password: secret

Gerard Bondur is a sales person and responsible for the regions Europe, the Middle East and Africa. After logging into the system you'll find yourself in the dashboard module. Gerard has a single dashboard with four dadgets (short for DAshboard gaDGETS). Dashboards allow to create a page (or multiple pages) which contains aggregated information such that, for example, key performance indicators are visible on a single glance. Users, such as Gerard, manage dashboards themselves. Alternatively they can choose to include dashboards created by an administrator. In our online demo-system you will only have read access to the dashboard and can thus not create new dashboards or change the demo dashboard.

Besides the dashboard module the second important module for users is the TeamSpace. To change to the TeamSpace switch modules by clicking on TeamSpace on the module bar on the top edge of the screen. Gerard is part of the sales team and has thus access to the Sales TeamSpace. The Sales TeamSpace is a shared workspace for all employees of the sales department. Naturally there can be many TeamSpaces and users can have access to multiple TeamSpaces. We will take a closer look at TeamSpace later on in this introduction.

Before we get to the TeamSpace note that the UI of ReportServer is structured into several areas. On the very top you find the module navigation which allows you to access various areas of ReportServer (you have already seen the Dashboard and TeamSpace modules; other modules are for example the Scheduler overview or the Administration module). On the top right you find a link to the user's profile allowing the user to change various settings. Next to the link to the user's profile you see a global search field.

Beneath the module navigation you will see the currently active module: in our case the TeamSapce. The TeamSpace is again structured into two parts. The left part is modeled after the Windows Explorer and allows to navigate through folders to the various report objects. On the right you find detailed information to the currently selected objects. Dragging the border between the two windows allows you to resize the windows.

Let us start with the execution of a dynamic list which is the ReportServer way of ad hoc reporting. Access the folder Customers and open the report T_AGG_CUSTOMERS - Basis by double clicking its icon. This report accesses an aggregate table in the warehouse and allows the user to freely configure which kind of data from that table he or she wants to select.

After opening the report you will find yourself in the list configuration view (the different views are listed on the left hand side). Begin with clicking on the button select columns to start adding data to your report. The opened popup contains a list of all available columns that you can choose from for this dynamic list. You can select columns by double click or via drag and drop from the left to the right. Please select the following columns (it might be easier to use the search box to find the columns):

CUS_CUSTOMERNAME
Y_VOLUME

Click on apply to confirm the selection. You should now be back in the list configuration view and the two columns should have been added to the configuration.

To view a preview of your report click on "preview" in the left column. The preview view displays the first 100 data-records and provides some metadata at the bottom. The bottom toolbar also allows you to page through the data. Via right click on data cells you can access several functions such as sorting, filters and formats. These and additional functionality can also be accessed from the list configuration view ("configure list" in the left column). To see a record in detail, double click on it. To export your report into one of various formats you can click on "Excel-Export" (for Microsoft Excel) or on the little arrow next to it. The configuration of a dynamic list (which columns, filters, aggregations, etc.) can, of course, be saved as a so called variant such that it can be easily accessed again at some later point. In the read-only demo system this functionality is, however, disabled.

Now go back to the TeamSpace (click on Team Spaces in the module navigation at the top of the page) and select the report Customermap (located in the root folder of the TeamSpace). For selection, a single click is sufficient. A double-click, on the other hand, runs the report.

ReportServer's scripting interface allows to incorporate almost any kind of report format such as, for example, a view of the existing customers displayed on google maps. As you can see, additional information for a report including a preview of the report is directly displayed in the detail panel on the right hand side of the TeamSpace. Click on one of the customers to get some additional information and a link to a dynamic list displaying detailed information for that particular customer. If you click on the link you'll be forwarded to that dynamic list. Notice that the new report is opened in a tab which allows you to easily go back to any previously opened report. To close a report click on the cross icon on the upper right or on the tab (at the bottom).

ReportServer integrates the jXLS library which allows users to directly export data into a preconfigured Excel template thereby bridging the gap between simple list like reports and highly formatted reports such as as Birt, Jasper or SAP Crystal Reports. To get a feeling of what can be achieved using Excel templates go back to the TeamSpace and open the report OrderReport Template (located in the Customers folder). Then click on "Template-Export".

TeamSpace Administration and Pixel-Perfect Reporting

Administration