LCL003 Enhance Query Results Report and Chart

LANSA Client

LCL003 - Enhance Query Results, Report and Chart

LANSA Client allows you to present your data in a variety of ways. Once you have a query's results in the Results window, you can:

  • Add totals, sort the data, group it and contract or expand it
  • Display it in a report format
  • Display it as a chart or graph
  • Copy some of it onto the System Clipboard and paste it into another application
  • Change or delete the data and insert new records.

Each of these features is described in detail in Creating and Running Queries.

Before you can do this tutorial, you will need to have created the sample query as described in LCL002 - Run a Simple Shipped Query.

When your query is ready to run, you can learn ways to enhance it using these steps:

Step 1. Add Summaries

Step 2. Group your Results

Step 3. Contract and Expand your Results

Step 4. Display the Results using a Report Format

Step 5. Chart Results

Step 6. Customize the Chart

Step 7. Use the Hot Chart Facility