4 8 2 Attach an Existing Report to a Query

LANSA Client

4.8.2 Attach an Existing Report to a Query

To display your results using an existing report format, select the Results menu from the menu bar and choose the Report command.

If you have not yet saved the results of your query, LANSA Client will ask you to confirm that you wish to proceed.

If there is a predefined report format file with a name matching the file name of your results, your results will be immediately displayed in the report layout on your screen.

If there is no predefined report with a matching file name, LANSA Client will invoke the Report Writer so that you can create a new one.

Note: LANSA Client locates the required report by finding a report format file with the same name as the query's file name.

For example,

a query called:

QUERY1.LCQ

would have a result file called:

QUERY1.DBF or QUERY1.MDB

and a report format file called:

QUERY1.RPT

If it is not possible to use the same name for the query and the report format, you can link them using the Linked Query Option command in the Query menu.

If you specify that the results of a query are to be displayed as a "report" using the Output To command, the results will be immediately displayed in the required report layout, bypassing the Results window. In this case, the results are automatically saved in a file created using the query's file name with a DBF/MDB file type depends on the default DB used.

Further Information

Ý 4.8 Convert the Results to a Report