DevNet Sample Applications
One of the fastest ways to learn how to develop applications using Logi Info is to examine sample applications. Numerous free sample applications, prepared by Logi developers, are available on the Developer Network web site for your use. Logi Studio contains features, discussed in this topic, that make downloading and running these applications easy.
About the Sample Applications
DevNet features more than 50 sample applications. Most of them can be run directly from the website, and all can be downloaded and examined to understand various development techniques or used as a basis for your own projects. You can also examine the code of the key definitions in your browser, without downloading the complete application. We also encourage you to submit your own sample applications for inclusion on DevNet.
Download and using the sample applications is easy.
You can access them from the Getting Started dialog box in Logi Studio, shown above, or from the DevNet web site main menu by selecting Knowledge Base > Logi Info > Samples.
Both links take you the DevNet Samples page. The key features of this page are numbered in the image and include:
- You can choose between sample Applications, Plug-ins, and Themes.
- The most popular samples are shown for easy access here, and all of them are shown lower down the page.
- The selected sample appears here with a small image, compatibility information, and a description of the techniques demonstrated.
- You can run almost all of the sample applications immediately by clicking the Run App button; the sample application will run in a new browser window so you can see it and interact with it. You can click the Download button to download the sample to your computer (see below).
- If you just want to look at the sample's source code, or copy a small part of it without doing a complete download and install, click a source file link here to open it in another browser window.
Downloading Sample Applications
If you choose to download a sample application, they're made available as files with an ".lgxzip" file extension. They're usually quite small and download very fast. You should see a dialog box after clicking the Download button. If you choose Open with, the file will be saved to a temporary location on your computer and Logi Studio will launch automatically to open it.
If you choose Save File, the file will be saved on your computer and you can then use a file system tool, such as File Explorer, to navigate to it and double-click it, which will launch Logi Studio. Once Logi Studio launches, it will automatically open and extract the downloaded application, then save it to this location (may vary, based on OS): C:\Documents and Settings\<username>\My Documents\LogiXML Samples\<SampleAppName>
Then, Logi Studio's New Application wizard will run. This wizard will install the application, register it with your web server, and test it. Once the wizard completes, you can run the application immediately. When you upgrade Logi Info to a newer version, samples you have downloaded and worked with previously will not be affected.
Almost all of the sample applications include XML data files that contain sample data. As a result, they can be run right "out-of-the-box" without any need to configure a database server connection. In many cases, however, the sample applications contain commented SQL elements that can be used with a database connection to produce the same results. If you wish to work with the samples using SQL queries and you have the Northwind database, you can remark the XML data elements, un-comment the SQL data elements, and configure a database connection in the _Settings definition. The applications include notes that guide you in doing this.
The following sample applications, with their source code, are available on the DevNet web site. Click a title link below to run the application. See the DevNet Sample Apps page to examine and download sample code.
This sample application demonstrates use of the Analysis Chart element. The Analysis Chart allows users to dynamically alter the chart types and data at runtime directly from their browser. Chart types available include: Pie, Bar, Line, Curved Line (Spline), Scatter, and Heatmap.
This sample application demonstrates use of the Analysis Grid element. The Analysis Grid allows users to dynamically alter the visible report directly from their browser. Options demonstrated include: Add new columns from user-defined formulas, create five kinds of charts, create dynamic crosstab tables, export data to CSV, Excel, or PDF.
This sample demonstrates the use of the Animated Maps, which are animated, interactive, data-driven, Flash-based maps for Logi applications. Developers can use them to display geographical data distributed by category, regions, or entities. Usage examples include statistical display of data, election results, survey results, or business intelligence such as "Revenue by Regions" or "Revenue by States". They do not work with zip codes or geocoded (latitude- and longitude-based) data.
This sample application demonstrates how to create a basic chart and is a good introduction to charts for new developers. The techniques demonstrated include: Creating a basic Bar chart, adding a 2nd data series (shown as stacked bars), adding a legend and data-based tooltips.
Basic Data Table
This sample application demonstrates how to create a basic data table and is a good place for new developers to begin. The techniques demonstrated include: Creating a basic table, using a style class for alternate rows, using a Condition Filter to limit rows, adding a Calculated Column, adding a Summary Row, freezing column headers and scrolling the rows.
This sample demonstrates Bookmarks, a mechanism for saving and recalling the user-configurable settings and request parameters for a report, at runtime. They're especially useful when working with "super elements" such as the Analysis Chart, Analysis Grid, and OLAP Grid.
This sample application demonstrates the Chart Grid element. The Chart Grid is a table filled with charts, representing separate data sets for each cell. Options allow the user to dynamically interact with the data at runtime, under developer control. The sample application demonstrates the use of: Chart Grid Panels, chart popup zoom panel, drillthrough to underlying data in a detail report, Time Period Columns for X-axis date data, and techniques for saving, restoring, reseting, and refreshing the grid.
Chart Canvas Charts
This sample application, one of our "Solutions" series, demonstrates a variety of Chart Canvas Charts and advanced development techniques, including Bar, Bubble, Pie, and Scatter chart series, Bar and Indicator gauges, tabs and AJAX refresh of report sections, use of subreports, use of a custom theme, and the use of custom Quicktips with charts.
This sample application demonstrates the Crosstab table. "Crosstabs", as they are frequently called, are used for comparisons, often over time, between different values and can "pivot" the data in unique ways.
This sample application demonstrates the use of the Dashboard element for presenting reports, charts, and key performance indicators. Features demonstrated include: Dashboard with 12 different example panels, customizable panels and layout, adjustable reporting parameters, panel updates using refresh timer.
This sample demonstrates the Data Calendar element, including: Monthly and Weekly data-driven calendars, data-based links embedded within the days on the calendar, application of Conditional Classes based on data, calling and getting data back from a popup calendar.
This sample demonstrates basic techniques for grouping data, including: grouping on a single column, "distinct" grouping, grouping on multiple columns, grouping and generating group aggregates (sum, count, etc.), grouping and displaying summarized data, and hierarchical grouping.
This sample demonstrates elements that add new columns in datalayers, including Aggregate (Count, Sum, Min, Max, etc.), Calculated, Difference, Moving Average, Percentage Total, Rank, Running Total, Sequence, Date formatting and CXMLDate function, and Time Period (parses dates and times).
Definition Modifier Files
This application demonstrates the effects of a Definition Modifier File (DMF). DMFs allow Logi Info developers to modify any of the elements or attributes in a report definition, based on conditional criteria, at runtime. In this sample, when a DMF is included, the report's data table column header text is translated to French and export links are added to the report footer.
This sample demonstrates the Dimension Grid element, which displays data from a XOLAP cube. Featured elements include: Dimension Grid, XOLAP Cube, XOLAP Dimensions and Measures, XOLAP Levels, DataLayer.XOLAP, and Calculated measure. The sample app also demonstrates techniques for saving, restoring, and resetting the Dimension Grid settings.
This sample demonstrates how to populate three different types of Excel templates with data from a data source. The following Excel template files are provided: Simple Demo, Billing Statement, Form with Calculations, and Invoice.
This sample application demonstrates the use of Action elements to export reports to various formats, including CSV, Excel, Adobe PDF, Word, and XML files, use of Excel Column Format elements to control formatting, and use of built-in Show Modes values to control which elements are exported.
This sample demonstrates techniques for uploading and saving files to the web server. Uploads can be restricted by file size and file type. Due to security concerns, this sample can only be downloaded from DevNet, it cannot be run.
This sample demonstrates Needle, Indicator, and Bar gauges, including Needle Gauges in Round, Half-Round, Quarter-Round, and 3-D configurations, Balloon Bar and Bullet Bar gauges, Vertical (thermometer) and Horizontal Bar gauges, and a data table with embedded Indicator Gauges.
This sample demonstrates the use of Google Map elements, which work with the Google Map web service. A Google Map is an interactive geographic map that can be programmed to identify locations, based on data. Polygon and polyline overlays can be added based on GIS data. Markers and regions can be clicked to drill-down for detail information.
This sample demonstrates the Chart.Heatmap element, which produces one of the most unusual charts found in Logi reporting products. Heat Maps display data graphically in a way that's intuitively easy for people to understand. Information is shown in blocks and the size of the blocks is set by one data column, while its color is set by another.
This sample demonstrates the use of Leaflet Map elements, which work with public map tile servers such as MapQuest, OpenStreets, and Bing. A Leaflet Map is an interactive geographic map that can be programmed to identify locations, based on data. Polygon and polyline overlays can be added based on GIS data. Markers and regions can be clicked to drill-down for detail information.
This sample demonstrates Mobile Reporting features which allow developers to create Logi reports for mobile devices. Features demonstrated include: HTML table, Bar charts with auto-sizer, Gauges, Mobile Dashboard, Data table with demand paging, and user input examples.
This sample demonstrates the OLAP Grid super-element. The OLAP Grid displays data retrieved from an OLAP cube, along with controls that allow users to interactively modify it. At runtime, users are able to select Dimensions for the left and top axes, select Measures, select Filters for slicing the data, drill-down on Dimension members, create a variety of charts, and export OLAP Grid data to Excel. Requires connection to Microsoft SQL Server Analysis Services and an AdventureWorks database cube.
This sample demonstrates how to fill-in two different types of PDF Form Templates with data from a datasource. The example form templates include 2005 Federal Tax Form 941, Single Invoice, and Multiple Invoices.
This sample application, one of our "Solutions" series, demonstrates a variety of Chart Canvas Charts and advanced development techniques, including, Google Map, Bar and Pie chart series, and combined Line and Area chart series, Balloon Bar gauges, Tabs and AJAX refresh of report sections, use of subreports, use of custom Quicktips with charts.
A Logi .NET Plug-in is a compiled assembly (.DLL) containing custom code that runs when page requests are processed. Plug-ins make it possible to run your own customized code, extending the functionality provided by Logi products. Example actions include: modifying report definitions before they're rendered, creating or modifying application data, getting data from unusual sources, modifying the finished HTML response stream before it is sent back to the browser, interacting with the web server OS, and writing custom messages to the Debug Trace page. This sample can only be downloaded from DevNet, it cannot be run.
A Logi Plug-in for Java is a Java class containing custom code that performs actions while each request is processed. Plug-ins make it possible to run your own customized code, extending the functionality provided by Logi products for building reports. Plug-ins can modify definition files before they're rendered, create or modify data from DataLayer elements, modify the XHTML response stream before a page is sent back to the browser, set session variables, and more. This sample can only be downloaded from DevNet, it cannot be run.
This sample application demonstrates the Popup Panels element, which extends popup functionality beyond the Popup Menu. This element provides a fully-functional, configurable window that can include sub-reports, images, and other standard visualizations. Examples include: showing a modal popup panel from a link, showing/hiding a non-modal popup panel using onMouseOver and onMouseOut events, using a popup panel for simple data entry (such as a login box), and more.
Process Task: Compress Files
This sample application demonstrates the use of a Process task to compress and extract files and folders on the web server. Features demonstrated: run a report, save it as a file, and compress it into a .zip file; compress a folder and all its files into a .zip file; extract a single file from a .zip file; and extract an entire folder, with multiple files, from a .zip file. This sample can only be downloaded from DevNet, it cannot be run.
Process Task: Export
This sample application demonstrates the use of process tasks to export reports to various formats, including: create a new temporary folder for the exported files, export report as a CSV file, export report data to an Excel file and format the data for use in Excel, export report as a Word document, export report as an Adobe PDF file, and export report data to an XML data file. This sample can only be downloaded from DevNet, it cannot be run.
Process Task: Scripts
Process Task: Send Email
This sample application demonstrates the use of a process task to send reports via email. Techniques shown include: evaluate request variable for conditional processing, build and set filename using session variables, if necessary create a new temporary folder for attachment file, send email with report embedded within it, send email with report as a HTML attachment, and send email with report as a PDF attachment.
Process Task: Update Table
This sample demonstrates the ReportCenter family of elements, which provides an easy and flexible way to implement a reports menu. Features demonstrated include: building a simple menu based on report definitions, adding "folders" which allow you to group reports by function or other arbitrary criteria, adding saved Bookmarks to the menu, so reports can be run with specific parameters and customizations.
This sample demonstrates use of Scheduler family elements to create a Scheduler Management Console application. Techniques include: using DataLayer.Scheduler to retrieve and display schedule information, using the Schedule element UI and other UI elements to gather Scheduler task criteria, and using Process tasks to create, update, delete, and run Scheduler tasks. The Logi Scheduler must be installed and running before using this sample app. This sample can only be downloaded from DevNet, it cannot be run.
This sample demonstrates techniques for creating reports that can be scheduled to run on a recurring basis, using the Logi Scheduler, by the end user at runtime. This sample can only be downloaded from DevNet, it cannot be run.
Security - Standard Authentication
This sample demonstrates the use of Logi Security, with Standard Authentication, and a custom security database. Techniques include: use of customize logon page, authentication and rights from custom DB, security-based report access restrictions, security-based data filtering, and security-based data display restrictions. Test credentials are displayed on the logon page.
Security - Session Authentication for Single Sign On
This sample demonstrates how to set up session authentication, which provides a single sign-on (SSO) method. The SSO method enables custom handling of authentication logic and is used when: a developer wants to reuse existing OAuth, SAML, or other existing token-based authentication from the Parent application; Logi Securekey does not work in the environment; or complex management of user state.
Security - NT Authentication
This sample demonstrates the use of Logi Security with NT Authentication and domain-based security. Techniques include: getting authentication, roles, and rights from a domain; security-based report access restrictions; security-based data filtering; and security-based data display restrictions.
This sample application demonstrates Tabs and Tab Panels. Top, left, and bottom tab locations are shown.
Template Modifier Files
This sample shows how to use Template Modifier Files to customize the user interface in super-elements, such as the Analysis Chart, Analysis Grid, and Dashboards. Techniques include: translating titles and captions to another language, altering the options in the AG's Display Format selection list; and changing the AG Table panel Export options.
This sample shows how to use the Text Cloud element to create unique visual depictions of the relative weightings of words and phrases. It uses an XML data file that contains the Top 100 words and phrases from the DevNet web site search log over a two week period.
This sample application illustrates the use of Themes, by allowing you to switch quickly between the themes available on your system. Themes allow you to quickly apply a professional and consistent appearance to your Logi apps.
This sample demonstrates various User Input elements and the methods for accessing the values entered. Elements included are: Input Checkbox, Input Color Picker, Input Combo List, Input Date, Input Date Picker, Input Grid, Input Password, Input Radio Button, Input Select List, Related Input Select Lists, Input Slider, Input Text, Input Text Area, and Input Time.
This sample application demonstrates the use of Logi applications with web services. This sample demonstrates techniques for connecting to, and retrieving data from, a Web Service. Examples of interactions with both REST- and SOAP-style web services are included. The reports use public websites; Logi Analytics has no control over the continued availability of the sites or their content.