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,