oReport.SetDataSource(dsStaff);which I hoped the report would then use, instead of trying to reference the delete table. I get the following error... which I take to mean that the crystal report can't find the table. Any ideas how to make this work?
Logon failed. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed.>If you present a datasource with the same table name as the report you designed the report with, Crystal will work fine with it. What I've done on a few reports is build the sql select statement in the form where the user selects his report criteria, then pass that to the constructor for the form that has a CR report viewer control on it. That form creates a table or data set with the same name and fields, and then uses the SetDataSource method to tell the report to use that as the data source.