To drag and drop OLE objects

This procedure assumes that you have Microsoft Excel or another spreadsheet program on your computer that is an OLE server application.

  1. Open both Seagate Crystal Reports and Microsoft Excel and size the program windows so that they are both visible. You will need to be able to see both the object's origin and its destination.
  2. Open an existing report in Seagate Crystal Reports.
  3. Create a spreadsheet in Microsoft Excel by typing the numbers one through ten (1-10) in cells A1 through A10.
  4. Select cells A1 through A10.
  5. Move the cursor to the left edge of the highlighted cells until an arrow pointer appears.
  6. Press the left mouse button and hold it down. This activates the cells to be moved. Since you're only going to copy the cells, press the Ctrl key and hold it down too.
  7. Drag the cells into the Details section of the report in Seagate Crystal Reports, and when you have the cells positioned, release the mouse button then the Ctrl key.
  8. Right-click the spreadsheet object in the report and observe that it is identified as an OLE object and that the second command from the last identifies it as a Worksheet Object.
  9. Double-click the spreadsheet object.

    The menus and tools change to those from the OLE server application. You can now edit the object in-place. The object is an embedded object. Any changes you make to the object will not affect the original.

  10. Click outside the object when you are finished.

    The menus and tools change back to those of Seagate Crystal Reports.



Seagate Software, Inc.
http://www.seagatesoftware.com
Please send comments to:
techpubs@seagatesoftware.com