Insert OLE w formula for document name

[Former Member]

Post Author: joemoceri

CA Forum: General

Hi, I'm still stuck using CR 8.5 and need to add a Word Doc to a report. I can do it as an "insert OLE object". However, I won't be using the same doc file all the time. The doc file name will be changing each time the report is run, so i need to add it as a formula.

I can't remember how to do it. I did it once in CR 7 and I don't have access to it.

How do i add a Word Doc into a report using a formula to specify the file name?

[Former Member]

Post Author: joemoceri

CA Forum: General

OK. I figured out how i did it in the past...

Microsoft Access - I added an ODBC link to the report to an external Access table with OLE objects in it.

Then on the main report i added the ACCES table via ODBC to get the ole object to appear on the report.

This allows a report to have a dynamic, OLE object to appear based on data in the report.