Hi,
I'm dynamically creating a Report Book and adding the client requested reports for presentation. The solution and code are working very well, but I've run into an issue that I can't solve. When exporting to Excel each report renders in a separate worksheet which is absolutely perfect. The challenge is how can I specify a name for the Excel worksheet so that it isn't the default Sheet 1, Sheet 2, etc.
Client is very adamant about wanting this feature so I'm struggling to find a workable solution. Any help you could provide would be really appreciated.
Thanks,
A3
I'm dynamically creating a Report Book and adding the client requested reports for presentation. The solution and code are working very well, but I've run into an issue that I can't solve. When exporting to Excel each report renders in a separate worksheet which is absolutely perfect. The challenge is how can I specify a name for the Excel worksheet so that it isn't the default Sheet 1, Sheet 2, etc.
Client is very adamant about wanting this feature so I'm struggling to find a workable solution. Any help you could provide would be really appreciated.
Thanks,
A3