%Since you're only going to copy the cells, press the Control key and hold it down too.

&Now drag the cells into the Details section of the report in Seagate Crystal Reports and release the mouse button and Control key when you have the cells positioned. That's all there is to it. You have just dragged an OLE object into your report.

' Save the file you created in Excel and close the application.

Right-click the spreadsheet object in the report and when the shortcut menu appears you will see that it's identified as an OLE object and the second command from the last identifies it as a Worksheet Object.

Double-click the spreadsheet object and the menus and tools change to those from the OLE server application so you can edit the object in place. The object is an embedded object. Any changes you make to the object won't affect the original.

Click outside the object when you're finished. The menus and tools change back to those from Seagate Crystal Reports.

You now have a working understanding of OLE. You can use these capabilities with Seagate Crystal Reports to make your work more efficient.

How to insert a graphic/picture as an OLE object

You can add already existing graphics/pictures to your reports as OLE objects or you can create new graphics/pictures from scratch.

Choose the OLE OBJECT command from the Insert menu. The Insert Object dialog box appears. You have two options when it comes to OLE objects. You can:

●insert an existing object, or

●create a new object directly in Seagate Crystal Reports using in-place editing.

426	Seagate Crystal Reports User’s Guide

When you choose the

Create New option...

Select the

Object Type

you want to

create.

The associated program will take control of Seagate Crystal Reports allowing you to create the object in place.

When finished, click anywhere on your report to exit the graphic program.

When you choose the Create from File option...

Type in the full path of the object you want to insert.

Toggle this option on if you want the object automatically updated.

If you do not know the path, click the Browse button to locate the object.

A frame approximating the size of the object (or icon) appears.

Position the OLE object (icon shown here) where you want it to appear in your report.

OLE

427

428	Seagate Crystal Reports User’s Guide

19 Subreports

What you will find in this chapter...

What are subreports?, Page 430

Unlinked vs. linked subreports, Page 430

Unlinked, Page 430

Linked, Page 431

Database links vs. subreports in one-to-many situations, Page 433

Linking to/from a formula field, Page 442

Linking unindexed tables, Page 443

HANDS-ON (Subreports), Page 433

Subreports

429