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