Works: Copying a Report from One Database to Another (80672)



The information in this article applies to:

  • Microsoft Works 2.0
  • Microsoft Works 3.0
  • Microsoft Works 4.5
  • Microsoft Works 4.5a
  • Microsoft Works for Windows 95, version 4.0
  • Microsoft Works for Windows 95, version 4.0 4.0a

This article was previously published under Q80672

SUMMARY

You can copy a report from one database to a different database in Microsoft Works for Windows. The procedure to follow is listed below. This procedure will work best if the two databases are identical in structure.

MORE INFORMATION

For example, you may have a database with old information but a good report and another database with new information but no reports. Using the following method you could copy the report from the old database to the new database:

Works version 3.0 and Works 4.0, 4.5, and 4.5a for Windows 95:

  1. Open the database that you want to copy the report to.
  2. Open the database with the existing report.
  3. From the View menu, click the report you want to copy.
  4. Highlight the part of the report definition you want to copy from.

    To copy the entire report, highlight the entire report definition.
  5. From the Edit menu, click Copy.
  6. Switch to the database where you want the report to be copied to.
  7. From the Tools menu, select Create New Report. Do not enter anything in any of the dialog boxes. Click OK to display the blank report.

    In Works 4.0, on the Tools menu, click ReportCreator. Name the report and click OK. Then click Done to creator an empty report.
  8. From the Edit menu, click Paste. The report will be placed in the blank report definition screen. Make adjustments to the titles and instructions as necessary.
NOTE: If you copy the field contents for a field in the original report that does not exist in the target database, you will see =ERR instead of the name of the field.

Works for Windows version 2.0:

  1. Open the database that you want to copy the report to.
  2. Open the database with the existing report.
  3. From the View menu, click the report you want to copy.
  4. Highlight the part of the report definition you want to copy from.

    To copy the entire report, highlight the entire report definition.
  5. From the Edit menu, click Copy.
  6. Switch to the database where you want the report to be copied to.
  7. From the View menu, click Create New Report. Do not enter anything in any of the dialog boxes.
  8. Choose OK to display a blank report definition screen.
  9. From the Edit menu, click Paste. The report will be placed in the blank report definition screen. Make adjustments to the titles and instructions as necessary.

    NOTE: If you copy the field contents for a field in the original report that does not exist in the target database, you will see =ERR instead of the name of the field.

REFERENCES

For more information about how to perform this task in Works for Windows 95, see your Works printed documentation or online Help.

"Microsoft Works for Windows User's Guide," version 3.0, pages 429-430.

"Microsoft Works for Windows User's Guide," version 2.0, pages 352-353.

Modification Type:MajorLast Reviewed:11/15/2004
Keywords:kbinfo KB80672