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
