Introduction
The Supermart Dashboard sample is designed to provide a view into the performance of a retail store chain. It is comprised of 3 reports designed with Jaspersoft iReport Designer. JasperReports Server Professional Edition was used to position each report and apply the Start and End Date input control. The dashboard is intended to be viewed by Supermart executives and managers. The data is associated to products, stores, and customer information. To navigate to this dashboard, navigate to our repository by hovering over the view button and clicking on "Repository".
From the repository, navigate to the Public -> Samples -> Dashboards folder and find the Supermart Dashboard.
This tutorial will focus on four key dashboard items.
Item 1 - Interactive Pixel Perfect Report Drilldown
Drill down to an underlying Customer Detail report by clicking on Ida Rodriguez's name in the red box to explore key features like:
- Formatted pixel perfect reports
- Interactive table with header formatting options to enable sorting, filtering, and conditional formatting
Pixel Perfect Customer Detail Report
What is Pixel Perfect Reporting?
Jaspersoft reports can be designed for pixel perfect layout for invoices, client statements and more. These reports are typically formatted for print or for a specific online layout. The barcode in this report can be printed or used for on-screen scanning. Pixel perfect reports can also be fully interactive to give the user more options to tweak or customize the report. They also can be easily exported to different formats such as PDF, XLS, XLSX, XML, HTML, XHTML, CSV, DOC, and ODT
Interactive Tables
To engage the interactive functionality of a table, simply click on the column heading to bring up a menu with four selectable buttons.
- Column Options allows the user to hide a column as well as access the formatting menu
- Column Filters allows the user to filter the data by specific criteria
- The up and down arrows will immediately sort the column in ascending or descending order.
Step 1. Formatting Columns
The Column Formatting option allows the user to hide a column or to access the formatting menu. From the formatting menu, the user can format the column header as well as the column values.
Click here for a more in-depth look at JasperReports Server's Column Formatting.
Step 2. Filtering Column Data
Set the Column Filter to only show products with 10 dollars or more of sales.
Click here for a more in-depth look at JasperReports Server's Interactive Filtering.
Step 3. Sorting Column Data
Sort the Sales Column to descend.
Click here for a more in-depth look at JasperReports Server's Interactive Sorting.
Item 2 - Interactive Ad Hoc Report Drilldown
Designed with: Jaspersoft BI Professional/Enterprise using the Ad Hoc tools of JasperReports Server
Select the Profit Gauge to drill down to the Profit Detail report.
Follow the lettered steps to explore these features:
- Use parameters or input controls to narrow the report result set
- Change the chart type to display the data differently
- Explore the interactive table to format, sort, and filter the report data
- Select and de-select chart data to change the view of the chart
- Save customized reports in the repository
Step A. Change the input control to show only food
Step D. De-select Female Sales to see the chart re-draw with only Male Sales.
Item 3 - Interactive Zoom
Charts feature an interactive zoom function that lets you quickly see specific areas of the chart. To use, simply click and highlight the portion of the chart you'd like to see and the chart will appropriately resize the view in greater detail.
Item 4 - Dashboard Input Controls
The Supermart dashboard has an input control to give the user a way to quickly change the time period of the report data. Simply change the Start month and End month values and click the Submit button. The other reports on the dashboard will auto update based on the data pertaining to that time period.
Recommended Comments