LANSA Client Tips

Archive

• Performance issue with LANSA Client Queries on V7R1 
  - LANSA Client
  LANSA Client Queries slows down after migrating to V7R1
• Error saving to file when saving a query in LANSA Client with Terminal Server
  - LANSA Client
  An error can be generated saving a LANSA Client query to file using Terminal Server.
• Trigger LANSA Client queries from a report
  - LANSA Client
  Technique to trigger a query from a report which should run to retrieve data from the AS/400 or NT server.
• Upgrade to Crystal Reports for LANSA
  - LANSA Client
  There are several ways to approach the upgrade of Crystal Reports for LANSA.
• LANSA Client networks installation instructions
  - LANSA Client
  Instruction on installing LANSA Client on the network.
• Batch Query and Report execution
  - LANSA Client
  Schedule LANSA Client queries or call a query from an application.
• Library List in LANSA Client
  - LANSA Client
  Query files from your own Library List.
• Crystal Reports Data Dictionary
  - Crystal Reports for LANSA
  Developing reports even easier with Crystal Reports Data Dictionary.
• Print "Range" selection criteria in report header
  - Crystal Reports for LANSA
  he Minimum and Maximum functions can be used to collect the lowest and highest value of a field, and use these to print the actual range of the data in your report in the report header.
• Converting a text field to a number
  - Crystal Reports for LANSA
  The ToNumber string function in Crystal Reports provides an easy way to convert numbers in a text field to a number field.
• Resizing a set of columns in LANSA Client (including last column)
  - LANSA Client
  It is easy to resize a set of columns to the same size and at the same time.
• Grouping by week, month, quarter or other period
  - Crystal Reports for LANSA
  The grouping facility in Crystal Reports for LANSA makes it easy to group data by week, month, quarter or any other period.
• Using the same report with different database files
  - Crystal Reports for LANSA
  It is very easy to use a different file or set of files when running an existing report.
• Field conditions and performance
  - LANSA Client
  Whether field conditions are applied to fields from primary or secondary files will affect the performance of queries.
• Wrapping column headers over multiple lines
  - Crystal Reports for LANSA
  When a column header is too wide to fit 'nicely' above a report field, that column header can be printed over 2 or 3 lines.
• Record Selection in LANSA Client
  - LANSA Client
  Field conditions help you to filter data so that you only get the records you want.
• Suppressing duplicate printing of data in Crystal Reports for LANSA
  - Crystal Reports for LANSA
  The "Suppress If Duplicated" printing option allows the suppression of printing of repeated information.
• Fields that do not fit on a line in a report
  - LANSA Client
  Having too many fields to fit on a line, or a single field that is too long to fit anywhere in a report.
• Print non-matching records only (Outer Join)
  - LANSA Client
  Only the records in a file that do not have matching records in another file can be printed.
• Using a formula in your selection criteria
  - Crystal Reports for LANSA
  Records can be selected for a report based on a comparison of multiple database fields or calculated fields.
• Giving all fields a unique description
  - LANSA Client
  Fields with the identical descriptions can cause confusion for users when carrying out sorts and selections.
• Prototyping LANSA Client queries
  - LANSA Client
  Its not necessary to run a full LANSA Client query to test a report layout or check values in the file.
• Crystal Reports for LANSA Client: Print and Export options
  - Crystal Reports for LANSA
  Details many of the print and export options available.
• Barcodes in your reports
  - LANSA Client and Crystal Reports
  Detailed description of printing barcodes.
• Compiling and distributing reports
  - LANSA Client and Crystal Reports
  Compiling and Distributing reports.
• Customized Grouping
  - LANSA Client
  Customized Grouping is a facility that allows the user to group on a field which is not actually available in the database file.
• LANSA Client chart options
  - LANSA Client
  The charting options that will be used with a query can be saved.
• Using variables in your report
  - LANSA Client
  Using variables in your report, for example in a running total.
• Special characters
  - LANSA Client
  The special characters used in many European languages will not appear in LANSA Client reports unless one of the Report Option defaults for Crystal Reports is altered.