Inserting OLE Object (specific MS-Excel worksheet)

[Former Member]

Dear experts,

in my crystal report I have to insert 3 Excel worksheets in different parts of my report (containing different formatting so i connect them with the OLE option).

So the user would like to edit this in one Excel-file with 3 worksheets. so far so good:

one Excel-file with 3 worksheets

Is it possible to link the OLE-Object to a specific worksheet of my Excel-file like

OLE1:  myExcelFile.xls#sheet1

OLE2:  myExcelFile.xls#sheet2

OLE3:  myExcelFile.xls#sheet3

kind regards

ryan

[abhilash_kumar · Accepted solution]

Hi Ryan,

Well, at the moment you can only add the whole Excel Sheet as an OLE Object and not individual worksheets. Crystal Reports cannot control that unfortunately.

Please post this as an Enhancement at http://ideas.sap.com.

- Abhilash

Follow us on Twitter

Got Enhancement ideas? Try the SAP Idea Place

Share Your Knowledge in SCN Topic Spaces

[Former Member · Accepted solution]

Thank you Abhilash!

is it possible to set the size of the OLE-Object dynamic in dependence of the underlying document?

so if I add an excel or pdf that is 2 or more pages long, Crystal will just show the first page.

By double click the OLE object will open, but that's not practicable if I export the report to pdf and send it automatically to the user.

kind regards

ryan

[abhilash_kumar · Accepted solution]

Hi Ryan,

Crystal Reports only supports single-paged OLE Objects (PDF, Word, Excel ect). Which means multi-paged documents are not supported.

CR will always only show the 1st page of the document unfortunately.

Again, I would direct you to the Ideas Place for this too, although this has been brought up numerous times here and I guess the Idea might already be there. You just need to search and vote up!

- Abhilash

Follow us on Twitter

Got Enhancement ideas? Try the SAP Idea Place

Share Your Knowledge in SCN Topic Spaces

[JWiseman · Accepted solution]

hi Ryan,

the one page limit that Abhilash describes is a limitation of the windows ole32.dll...you'll have to plead your case to microsoft.

http://en.wikipedia.org/wiki/Object_Linking_and_Embedding

not really sure about a workaround for you either other than the following:

http://www.ehow.com/how_6924509_insert-excel-file-html-code.html

you'll have to first activate pass-through html on your enterprise or crystal reports server system and then you'll be able to insert an iframe on your report.

however, before you waste any time on this, any html that you add on to a report will not be printable via the crystal reports toolbar print mechansim, and cannot be exported.

if you want more info on activating pass through html, please see the page for webelements here

http://scn.sap.com/docs/DOC-7655

cheers,

jrw