Skip to Content
0
Former Member
Oct 26, 2007 at 07:02 PM

Reporting from an MS Excel datasource

8 Views

Howdy there,

I've been asked to look into a few issues when building a report based on data in an Excel spreadsheet...

The main issues I need to resolve (and from what I've seen, I don't think there's a way of doing it) is to dynamically specify the name of the file used as a data-source and being able to pull the tab name from Excel onto the Report.

Basically, the system is going to be used for recording / outputting proposals... Since each proposal will be recorded in its own file, ideally we'd like to be able to have a parameter which will then set the connection details to look at the correct spreadsheet.

Thanks for any help you can offer,

Mat