Print this page Request more informationHome > Products > LANSA Client

LANSA Client

Desktop query, reporting and charting

LANSA Client gives users GUI access to enterprise data on Windows, System i, UNIX and Linux servers. Report, chart and query from a single tool with unparalleled ease-of-use. Copy data to popular spreadsheets or other PC tools for analysis. Dramatically reduce the application development backlog by empowering users to create their own reports. You can even publish reports to Web sites.

LANSA Client integrates with Crystal Reports, the world’s most popular Windows report writer
LANSA Client integrates with Crystal
Reports, the world’s most popular
Windows report writer

Easy-to-use

With more than 100 pre-defined reports included you can choose from accounting, sales, inventory, manufacturing and dozens of other reports for fast reporting or use the Report Experts which help you to quickly create new reports and help you learn new product features.

Power users can create their own promptable queries with drag-and-drop ease. There is no need to learn SQL to define flexible record filters. LANSA Client integrates with Crystal Reports, the world’s most popular Windows report writer with over five million copies shipped.

The point-and-click application generation facility lets you package multiple promptable queries and reports into a single icon the ultimate in simplicity for any user.

You can create an icon on the desktop containing promptable reports and charts. Users simply click and select today’s requirements and their report is done. It can be printed, sent by email or pasted into Microsoft Office products.

Server-based control

You can centrally define and control query access within the LANSA Object Repository. You avoid time-consuming and error-prone replication of files and definitions.

Define simplified files in the LANSA Object Repository. Fields are given business names users find easy to understand. Navigation rules between files are defined, making it easy for users to find the data they need.

You can reuse these LANSA Object Repository definitions in other LANSA applications — saving you time and decreasing application maintenance.

A powerful Online Analytical Processing (OLAP) engine within LANSA Client allows dynamic grouping and summarizing of data
A powerful Online Analytical Processing
(OLAP) engine within LANSA Client allows
dynamic grouping and summarizing of data

Architected for the data warehouse

Typically, around 60 percent of the application development backlog is user reporting. But just giving users a query tool often results in more support problems.

LANSA simplifies the complexities of real systems into business dimensions. You can use LANSA’s award-winning development tools to simplify files and create a data warehouse that users can understand. Users can easily access internally described fields, multi-member files and multi-record format files.

A powerful Online Analytical Processing (OLAP) engine within LANSA Client allows dynamic grouping and summarizing of data. Pivot tables within Crystal Reports for LANSA Client allow drag-and-drop pivoting of rows and columns.

Publish reports to the Web

You can save new and existing LANSA Client reports in HTML format for publishing to the Web. No manual HTML editing is required.

Features:

Server Platforms

  • Windows XP/Vista, System i, UNIX and Linux

Query

  • Business names for fields and files
  • Auto-navigate multiple files
  • Easy drill-down to related files
  • Dynamic grouping and summary
  • Multiple filter conditions can be joined by boolean operators
  • Prompt for variable inputs

Rapid Application Development

  • Point-and-click creation of iconized application
  • Package multiple, promptable queries into a single application
  • Customized menu bar
  • Centralized help text

Reporting

  • Sub-reports
  • Multiple section reports
  • Form-style reports
  • Conditional reports
  • Mail merge documents
  • Enhanced cross-tab reports
  • Form letters
  • Mailing labels
  • Top N reports
  • Drill down summary reports
  • Over 15 Report Experts (wizards)
  • Over 100 pre-defined reports
  • Distribute reports on LAN, Intranet, Internet and email
  • Integrate data from PC databases
  • Save data to standard file formats including dBase, Excel and tab/comma delimited ASCII
  • Extensive data calculations
    • Simple arithmetic
    • Complex financial
    • Complex statistical
    • Complex scientific
  • Data Manipulation
    • Ranking on group totals
    • Formula language with over 160 functions
    • Multi-pass reporting, unlimited sorting, custom grouping
  • Includes graphs in reports
    • Over 80 styles plus customization
  • ActiveX (OLE) container with in-place editing
  • Combine text, fields, images and more in flexible editable objects