Previous Page Next Page
Track 1: Self-service Dashboard with JReport
Dashboard is a new way of information delivery. Users can create, edit and browse dashboards from the JReport Server user console using JDashboard. With pre-built library components, users can freely choose the objects they want to display in a dashboard, without having to know how these objects were created, what data sources to use, what styles to set, etc. Report data components and Visual Analysis templates can also be inserted in dashboards directly. A dashboard can hold multiple library components so that when browsing the dashboard users are able to see multiple data aspects. Within a dashboard, library components are able to communicate with each other via the message mechanism. This allows actions such as common filters to be applied to all the components of a dashboard even when coming from different data sources so as to achieve data synchronization. Furthermore, users can run reports and Visual Analysis templates directly by invoking the report studio and Visual Analysis inside JDashboard, without having to switch to the user console. This allows analyzing with different tools in just one JDashboard window.
Task 1: Create a dashboard and insert library components
Task 2: Insert a report component into dashboard
Task 3: Synchronize the components
Task 4: Use a slider to filter on Quantity
Task 5: Insert a third party gadget (stock widget)
Task 6: Export the library components
Task 7: Use the configuration panel to change parameters
Task 8: Share parameters among components
Task 9: Run a report in JDashboard
Task 10: Set a dashboard as the server home page
Note: A JDashboard license for JReport Server is required in order to perform this track. If you do not have the license, please contact your Jinfonet Software account manager to obtain it first.
Task 1: Create a dashboard and insert library components
- On the JReport Server Start Page, click Dashboards in the Create category. JDashboard is then displayed in a new window tab, with a blank dashboard created.

- Click the Resources button
on the toolbar to display the Resources panel, which lists all the data resources and components that can be inserted in dashboards.
- Expand the Component Library > Public Components > SampleReports folder and drag Sales by Category.lc to the dashboard body.
- Drag Crosstab.lc in the same folder to the right of the first component.
- Click
on the top right of the Resources panel to hide the panel.
- Click the Arrange button
on the toolbar to align the two library components.

- Click the Save button
on the toolbar.
- In the Save As dialog, replace Dashboard 1 with Products in the File Name text box, then click OK to save the dashboard into the My Reports folder in the server resource tree..
Task 2: Insert a report component into dashboard
Report components created from business views can be inserted in dashboards directly.
- Click
on the toolbar to display the Resources panel.
- Go to the Reports > Public Reports > SampleReports folder, expand Shipment Status Report.wls and drag TableComp to the dashboard body below the existing components. Hide the Resources panel.

- Save the dashboard.
Task 3: Synchronize the components
In this task, we want to click any value of the Category field in the crosstab to automatically update the chart. This is achieved by delivering a filter synchronization message between the two library components.
- Right-click on any Category value in the crosstab column header, Blends for example, and select Send Sync > Filter from the shortcut menu.

- The chart automatically receives the synchronization message because it is created based on the same business view as the crosstab and contains the field Category too. To view details of the message, right-click the chart and select Receive Sync. The filter message is shown in the Receive Sync dialog. Close the dialog.

- Click any value in the crosstab column header, for example Bold. The chart is filtered to show data of the Bold category only after it receives the synchronization message.
You may find that the crosstab is also filtered. This is because at report design time, the library component designer has predefined to make it receive a filter message too. You can right-click on the crosstab and select Receive Sync to view the details if you want.

- We will remove the filters from the components. Click the Clear Filters button
on the toolbar.
- Click
on the toolbar to save the dashboard.
Task 4: Use a slider to filter on Quantity
- Click
on the toolbar to display the Resources panel, then from the Toolbox node, drag Filter Control to the dashboard body below the table.
- In the Insert Filter Control dialog, input Sales Quantity in the Title text box and select Range Slider as the control type.
- Expand the Select Fields drop-down list. The two business views used by the three data components in the dashboard are listed. You can select a common field in both business views to filter the three data component at the same time via the slider. Here we only want to filter data components that use WorldWideSalesBV.

- Check Quantity in WorldWideSalesBV, then click outside of the drop-down list to close it. Click OK to insert the slider.

- Hide the Resources panel.
Next, we will use the slider to show the data for Quantity between 5000 and 8000 only.
- Uncheck the All checkbox on the slider. Drag the left arrow to set a minimum range 4983 and the right
arrow to set a maximum range 8031. The
chart and crosstab are filtered. The table uses the other business view so it is not changed.

- Save the dashboard.
Task 5: Insert a third party gadget (stock widget)
- Click
on the toolbar to display the Resources panel, then drag URL Frame from the Toolbox node to the dashboard body on the right of the slider. The Insert URL Frame dialog is displayed.
- In the Title text field, input My Stocks, and in the URL text box, type in http://edulifeline.com/includes/stocks_widget/.

- Click OK. The specified web page is then inserted into the dashboard.

- Hide the Resources panel and save the dashboard.
Task 6: Export the library components
- Click the Export button
on the toolbar. The Export dialog appears.
- Select Customize Layout from the Layout drop-down list.
By default, all the exportable library components are arranged using a tabular style according to their positions in the dashboard in the Design tab on the right. Each tabular cell can hold no more than one component. Sliders and gadgets cannot be exported so they are not available here.
Next, we will change the layout of the components a little bit by removing the crosstab on the right of the chart and adding it below the table.
- Right-click anywhere in the cell containing the crosstab, select Remove from the shortcut menu.

- Scroll down to the blank cell below the table. Drag Crosstab from the Resources box to the cell.

When exporting tables and crosstabs, by default only the data currently displayed in the dashboard will be exported. In our dashboard the table contains several pages and we can view only one page at a time, that is to say only the currently displayed page will be exported. We want to get the full data of the table in the exported result so we need a further setting.
- Right-click in the cell holding the table, select Filter from the shortcut menu, then choose the All option and click OK.
- Click the Export button
on the toolbar. In the Export dialog,
keep the default settings to export the dashboard to a PDF file.

- Click OK. The exporting process begins. When finished, you can open the PDF file to view the result.
- Close the Export dialog and save the dashboard.
Task 7: Use the configuration panel to change parameters
When a library component uses parameters and its configuration panel is enabled, you can make use of the configuration panel to change its parameter values.
- On the table, place the mouse anywhere on the title bar, then click the Options button
that appears on the title bar and select Edit Setting from the drop-down list to display the configuration panel.

- Click
in the value box for the Shipper parameter. The Enter Values dialog appears.
- Check the Custom radio button, select UBS Uniform Logistics and click
to add it to the right box, then click OK.

- Click OK in the configuration panel. The table now shows records of this shipper only.

- Save the dashboard.
Task 8: Share parameters among components
When two or more library components in a dashboard contain parameters that meet the following cases, the parameters can be shared among them. After sharing parameters, you just need to provide values to one group of the parameters and all related components will be able to receive them.
- The numbers of the parameters in each library component are the same.
- According to the parameter order in each library component, the orders of the parameter data types are the same. For example, the parameter data types in a component are String, Number, and Boolean. If there is another component in which the parameter data types are also String, Number, and Boolean, the two components fulfill the condition of the same parameter data types.
- It is up to users to make sure the to-be-shared parameters contain some common values.
In this task, we will insert two library components having similar parameters and see the difference between before and after the parameters are shared.
- Click
on the dashboard title bar to add a new dashboard. A new tab is created, labeled Dashboard 2.
- Click
on the toolbar to display the Resources panel.
- Expand Component Library > Public Components > SampleReports and drag Shipment Status Overview.lc and Shipments by Status.lc one by one to the dashboard body. Hide the Resources panel.
- Click the Options button
on the toolbar and select Share Parameter. The displayed dialog shows that the two library components have shared parameters. Close the dialog.

- Click the Enter Parameter Values button
on the toolbar. The Enter Parameter Values dialog lists the following parameters. Close the dialog.

Next we will remove the parameter share between the two components to see how many parameters we need to specify.
- Click
on the toolbar and select Share Parameter. In the displayed dialog, select either component and click the Cancel Share button on the top right, then click OK.
- Click
on the toolbar to access the Enter Parameter Values dialog again. Now it lists separate pairs of the Start Date, End Date, and Territory/Shipper parameters used by the two library components. Close the dialog.

- Click
on the toolbar to save the dashboard as Shipment.
Task 9: Run a report in JDashboard
A report can run in the corresponding report studio within JDashboard. In this task we will run a web report inside JDashboard without going to the server resource tree on the user console.
- Keep the Shipment dashboard active.
- From the Resources panel, drag Sales Detail Report.wls in the Reports > Public Reports > SampleReports folder to the dashboard body, then hide the panel.
- The report is loaded into a separate tab via Web Report Studio within JDashboard.

Task 10: Set a dashboard as the server home page
- In the web browser, change from the JDashboard tab to the JReport Start Page tab.
- Click Profile in the Manage category.
- In the Customize Server Preferences > General tab of the Profile page, check the Use a Dashboard checkbox for the Home Page option, then click OK. Click OK in the prompt message.

- Click Resources on the system toolbar, then go to the My Reports folder.
- Click Shipment.dsh in the folder, the dashboard is loaded into a new JDashboard window.
- Click
on the toolbar and you can see Set as Server Home is enabled on the menu list. Click the option to set the Shipment dashboard as the server home page.
- Refresh the JReport Console page and a Home label is added beside Resources on the system toolbar. Click it and you can access the Shipment dashboard immediately.

Previous Page Next Page