Tuesday, March 27, 2012

Embed excel object in report

Is it possible to embed an excel worksheet in a report? I have a workbook which contains some data and this data needs to be part of the report. What are my options and can this be done by creating a custom report item.

Thanks for your advice.

dipi


You cannot directly embed an excel object into a report. You can however use ODBC to retrieve the data from the workbook as an RS dataset and then create a table from the data.

Ian

No comments:

Post a Comment