I am using the Reports Viewer in a
VB.Net app that automatically loads existing Crystal reports, exports as pdf files and mails the pdf files to lists of email addresses - no problem with this. The problem is with reports that use Excel as the data source, when I try to refresh a report, the data source dialog box insists that I provide a Server (the Excel book) Login ID and Password which of course there isn't for an Excel sheet. Is this a bug in the Crystal Reports Viewer? is there a work-around? - HELP