Insert Excel spreadsheet as OLE

[cathyg18]

Hello,

I'm trying to insert an excel spreadsheet into a Crystal 7 report. The spreadsheet is 12 columns wide by 88 rows tall. I have no problems with the columns, but the rows truncate after 69 rows, and I've been unable to edit it to fit. I have tried editing the spreadsheet from within Crystal, then dragging the object handles to include all the rows I need. However, when I click to end editing, the rows still truncate. Crystal allows me to select the object handles while not in editing mode and stretch, but this just stretches and does not expose the additional rows.

I think I've lost about 1/2 my hair over this!

Any ideas?

Thanks,

Cathy

 

[theDeej]

Check out Article ID: c2006186 on Crystal's support site:

http://support.crystaldecisions.com/library/kbase/articles/c2006186.asp

It sounds like perhaps Crystal cannot split the object to span more than one page. The article suggests creating multiple objects. Perhaps you can create one object including rows 1-69 and the remaining with rows 69-88?