iryzhikov

IntroductionJasperReports Server comes pre-loaded with multiple sample reports. This page goes in depth into the funtionality of two reports that heavily feature Cascading Input Controls and Conditional Formatting. These samples are located in the repository within the Public -> Samples -> Reports folder and are called "Product Results by Store Type Report" and "Interactive Sales Report". [toc] Conditional Formatting - Product Results By Store TypeDesigned with Jaspersoft iReport Designer. Conditional formatting enhances the effectiveness of a report and is an important aspect of Jaspersoft's interactive reporting solution. To access the conditional formatting menu, click on the top of the column to trigger the menu option, then select the Formatting... item, then click the Conditional Formatting tab. This will bring up a series of formatting options to apply to the report. For each cell of data, when a condition is met you can apply a specific format for the cell to display, such as a change in color or font. WalkthroughEvery type of value can be conditionally formatted, including boolean, text and numerical values. This walkthrough will highlight the steps needed to create a fairly comprehensive set of conditional formatting parameters. Step 1. Start out with highlighting all recyclable goods green and all non recyclable goods red. Step 2. Then format by store type where type equals Deluxe Supermarket or does not equal Deluxe Supermarket Step 3. Create a more detailed filter for the Sales, Cost and Units columns. These new conditions will create a report that looks like this. These conditional formatting settings can be saved for future access. The save button on the upper right hand of the screen will save this newly formatted report in the repository. Click here for a more in-depth look at JasperReports Server's conditional formatting. Cascading Input Controls - Interactive Sales ReportCascading input controls are an intelligent way to narrow a selection of values more quickly. This feature allows the business user to find the data they need within a potentially large number of data categories. The cascading input interface intelligently narrows the data in order to get to the desired information. In this example, the user narrowed the result of the report to the Product Family: Drink -> Product Department: Alcoholic Beverages -> Product Category: Beer and Wine. From there the user selected all ten beers sold at Supermart. These parameters can be saved for future use. When there are saved parameters available for a given report, the option to use saved values will appear in the options menu. Saved values allow a business user to quickly drill access the data they need without constantly updating their search parameters. Once parameters are applied to the report, the report result set displays the data associated with the input controls, allowing the user to interact with the data. The resulting of the filters used in this guide, will create a report that chronicles every transaction for each of the 10 different beers sold at Supermart. The end of this report features a report summary. Click here for a more in-depth look at JasperReports Server's cascading input controls. Additional Report Sample GuidesJasperReports Server comes packaged with a multitude of sample interactive reports, dashboards and analytic views that highlight many key product functionalities. These articles will walk you through through some JasperReports Server's features. Dashboards & Interactive Reports - Supermart Dashboard Sample Data Analysis using Domain Sample Data Analysis using an OLAP Sample

JasperReports Server comes packaged with a multitude of sample interactive reports, dashboards and analytic views that highlight many key product features. These articles will walk you through through some JasperReports Server's features. Dashboards & Interactive Reports - Supermart Dashboard Sample Additional Interactive Reports - Cascading Input Controls & Conditional Formatting Samples Data Analysis using Domain Sample Data Analysis using an OLAP Sample

Jaspersoft OLAP - Store Segment PerformanceJaspersoft OLAP is a powerful data analysis environment that comes with a web-based UI that allows non technical users to analyze large data sets and perform complex analytic queries. Users can quickly slice, dice, pivot, filter, expand & collapse data with ease. The "Store Segment Performance" view is located in our repository within the Public -> Samples -> Ad Hoc Views folder. Jaspersoft OLAP is a R-OLAP powered multi-dimensional engine that lets users interact with data in a variety of aggregated levels from potentially very large data sets. Below is a screenshot of the "Store Segment Performance" view with a multi-level Dimensional Zoom slider engaged. To quickly see summarized or different slices of data, simply use the Dimensional Zoom slider. Slide the Store Type position to the left position to see All Store sales by Product Type rather than by Product and Store Type. All Store Sales by Product view From here, you can view Product Sales by gender by simply moving the Gender slider to the right. All Store Sales by Product by Gender view Click here for a more in-depth look at JasperSoft OLAP. Additional Report Sample GuidesAdditional Interactive Reports - Cascading Input Controls & Conditional Formatting SamplesData Analysis using Domain Sample Dashboards & Interactive Reports - Supermart Dashboard Sample

IntroductionA domain is a virtual view of a data source that is created and stored in the server without modifying the source. It allows administrators and power users to present data in business terms, allows for localization, and row or column level data security. Sample Domains are located in our Repository which is accessible by hovering over the view button. From the Repository, drill down to Public -> Samples -> Ad Hoc Views folder and select "Geographic Results by Segment" Domain to display the view below. Data Analysis using Ad Hoc & DomainsThis sample was designed with Jaspersoft BI Professional or Enterprise edition using JasperReports Server Ad Hoc and Domain designer tools Key features to explore: Quickly view or drill into different levels of data using the interactive charting and Dimensional Zoom toolbar on the upper right of the screenImprove your understanding of the data by changing chart types and applying filtersAnswer new questions by adding custom calculations to your data for on-the-fly insightStep 1. Using the Dimensional Zoom sliderThis interactive environment lets users explore their data based on the pre-defined Supermart Domain. The Dimensional Zoom tool is positioned to view the data by total Store Sales, Cost, and Unit Sales across Country and Store Type, filtered by sales greater than 19. When the view is run, it queries the provided sample database and caches the result set in-memory. Subsequent interactions with the data will be run against the cached result set. Format the chart labels by selecting the Format Chart located at the upper left of the chart area (just below the Row box). A box will pop up and input 25 to the Rotate X axis label box. Further aggregate your view of the data by country by moving the Dimensional Zoom tool left to view the Country level. Finally, move the slider all the way to the left to Totals across Store Sales, Costs, and Unit Sales. Step 2. Associate Different Data to your AnalysisYou can drag and drop new data fields to your visualization to associate additional data fields to your analysis. This might improve your insight or reveal new trends or questions related to your data. Expand the Sales-> Products folder within the Fields category and drag Brand to Rows box. Step 3. Explore your Data with Interactive VisualizationsQuickly analyze the performance of your Best, Best Choice and Better brands in four easy steps. Change the chart type to stacked bar - located to the upper left of the chart area (just under the Rows category)Right click on the Brand value within the Rows box and select Create FilterTo the right of the page you'll notice the Brand filter box. Lengthen the box size and then multi-select the three brands called Best, Best Choice and Better brandsSlide the Dimensional Zoom toolbar slider all the way to the right to re-draw the visualizationStep 4. Add Custom CalculationsThe Ad Hoc View shows Store Sales, Unit Sales, and Store Cost totals. Using this data we can calculate Total Profit by adding our own custom calculation. The Ad Hoc editor allows a user to create their own custom fields. To calculate profit using this Ad Hoc View, go to the Measures section on the bottom left of the screen and multi-select the values "Store Sales 2013" and "Store Cost 2013" then right click and select Create Custom Field .... The custom field interface will pop up and offer multiple functions. Select "(Store Sales 2013) - (Store Cost 2013)" and select "Create Field". The new custom field will appear in the measures section and will become part of the chart. Additional Report Sample GuidesJasperReports Server comes packaged with a multitude of sample interactive reports, dashboards and analytic views that highlight many key product functionalities. These articles will walk you through through some JasperReports Server's features. Dashboards & Interactive Reports - Supermart Dashboard Sample Additional Interactive Reports - Cascading Input Controls & Conditional Formatting Samples Data Analysis using an OLAP Sample

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. Interactive Pixel Perfect Report Drilldown Interactive Ad Hoc Report Drilldown Interactive Zoom Dashboard Input Controls 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 B. Change the chart type to a stacked column. You can also change the labels of the report by selecting the Chart Formatting option. Step C. Click the Total column, select the Table format icon, then apply a filter to remove Departments with profits less than 10,000. Step D. De-select Female Sales to see the chart re-draw with only Male Sales. Step E. Save the report for future access. Saving the report allows users to access filters, formatting and chart type changes from the past. These saved reports can be saved to and located in the repository. 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. Additional Report Sample Guides Additional Interactive Reports - Cascading Input Controls & Conditional Formatting Samples Data Analysis using Domain Sample Data Analysis using an OLAP Sample