Jump to content
JasperReports 7.0 is now available ×
  • Additional Interactive Reports


    iryzhikov
    • Version: v5.1 Product: JasperReports® Server

    Introduction

    JasperReports 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]

    Supermart_StandAlone_SampleGuide_DetailedPath.png.9933fc0aa01448b292e81e19a77a0bb3.png

    Conditional Formatting - Product Results By Store Type

    Designed with Jaspersoft iReport Designer. Conditional formatting enhances the effectiveness of a report and is an important aspect of Jaspersoft's interactive reporting solution.

    Supermart_StandAlone_SampleGuide_Home_ByStoreType.PNG.a8c7a723583a8e76cbe45aae95529a2f.PNG

    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.

    Supermart_StandAlone_SampleGuide_FormattingMarked.PNG.af0fd25c0c0e330260f9a294297d634f.PNG

    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.

    Supermart_StandAlone_SampleGuide_StandardCondFormatting_Sales.PNG.d526ccab7fe5f37a76ad5ee04825d354.PNG

    Walkthrough

    Every 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.

    Supermart_StandAlone_SampleGuide_Recycle(1).PNG.c06159958a6ec58f5bad1c237aeeb422.PNG

    Step 2. Then format by store type where type equals Deluxe Supermarket or does not equal Deluxe Supermarket

    Supermart_StandAlone_SampleGuide_StoreType.PNG.ca591ebaa7be8db673aa5a25d7d1010f.PNG

    Step 3. Create a more detailed filter for the Sales, Cost and Units columns.

    Supermart_StandAlone_SampleGuide_SalesFilter.PNG.347e56191e8da814f42d505e60cd6850.PNG

    Supermart_StandAlone_SampleGuide_CostFilter.PNG.2e5636cf03b389371099d6d3aa7c5628.PNG

    Supermart_StandAlone_SampleGuide_UnitsFilter.PNG.e1965a5336f1f4c080af643980e42d8f.PNG

    These new conditions will create a report that looks like this.

    Supermart_StandAlone_SampleGuide_AdvancedCondFormat(1).PNG.099caa116ceb70036507c5dcc2452c61.PNG

    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 Report

    Cascading 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.

    Supermart_StandAlone_SampleGuide_InterSalesReport_Home.PNG.9c84358719e9e3d94932308f403d969a.PNG

    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.

    Supermart_StandAlone_SampleGuide_Beer_CascadeOptions_SaveMarked.PNG.a1e961903713c14e24b84e9b976c1dc4.PNG

    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.

    Supermart_DomainView_SampleGuide_SavedFilter_Marked.PNG.e3b9445ad9258614d8d05415821ae07e.PNG

    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.

    Supermart_StandAlone_SampleGuide_page1.PNG.90b4d332bf0deb3aeebc7ffc2b479ee8.PNG

    The end of this report features a report summary.

    Supermart_DomainView_SampleGuide_SavedFilter_TotalReport.PNG.3886046df311b35407cd60041eb43ace.PNG

    Click here for a more in-depth look at JasperReports Server's cascading input controls.

    Additional Report Sample Guides

    JasperReports 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.

    Supermart_StandAlone_SampleGuide_DetailedPath.png.aea639d27f5e7f3836c02f2f32c7e755.png

    Supermart_StandAlone_SampleGuide_Home_ByStoreType.PNG.5cbb2c36c3dc5ad4312886c64e345229.PNG

    Supermart_StandAlone_SampleGuide_FormattingMarked.PNG.d2e6df32bd8490f9b5cb337675fc85b1.PNG

    Supermart_StandAlone_SampleGuide_StandardCondFormatting_Sales.PNG.db3af019f9550d097edaa7ccc887632a.PNG

    Supermart_StandAlone_SampleGuide_Recycle(1).PNG.22f0f5144aea486ced436560bd7b48c3.PNG

    Supermart_StandAlone_SampleGuide_StoreType.PNG.ff93179b1549df97abb333dceedf9eab.PNG

    Supermart_StandAlone_SampleGuide_SalesFilter.PNG.5dceeccc198a89b7c4bdb53553c01b2d.PNG

    Supermart_StandAlone_SampleGuide_CostFilter.PNG.be32d46474b37e0ea211418e7b8e25be.PNG

    Supermart_StandAlone_SampleGuide_UnitsFilter.PNG.cd25de72ab112e033a2ae7ca615283b6.PNG

    Supermart_StandAlone_SampleGuide_AdvancedCondFormat(1).PNG.3b6008d614ce4b69adff377fb7b62dc9.PNG

    Supermart_StandAlone_SampleGuide_InterSalesReport_Home.PNG.88b962111858cb144b5c8f232ad7574b.PNG

    Supermart_StandAlone_SampleGuide_Beer_CascadeOptions_SaveMarked.PNG.129cf1a5e213cba2dc344b10cb2914f0.PNG

    Supermart_DomainView_SampleGuide_SavedFilter_Marked.PNG.1113dd89e6614f0bec73478b65d4a792.PNG

    Supermart_StandAlone_SampleGuide_page1.PNG.453513fad52f89930ff48dbfff692953.PNG

    Supermart_DomainView_SampleGuide_SavedFilter_TotalReport.PNG.e6596ba0e3f93583dd17d46c922401f8.PNG


    User Feedback

    Recommended Comments

    There are no comments to display.



    Guest
    This is now closed for further comments

×
×
  • Create New...