Background:
I am using ASP.NET to interface with Crystal Enterprise 10. I am using (almost exactly) the Sample Web Application from Crystal. In a nutshell, the sample Web App connects to the CE InfoStore to display a list of reports, you select a report, it connects to the InfoStore and retrieves the Report as the ReportSource to a CrystalReportViewer control
ie
Problem:
I need to be able to change the Database that the Report runs against at Runtime. Using just Crystal Reports this seems like a simple (relatively speaking) task, you load the report into a report object, iterate through the collection of tables in the report, and set the connection info for each table. I cannot seem to find an equivalent way to do this with CE though, there is no report object, there is just the viewer control. Does anyone have any ideas how to do this?
I am using ASP.NET to interface with Crystal Enterprise 10. I am using (almost exactly) the Sample Web Application from Crystal. In a nutshell, the sample Web App connects to the CE InfoStore to display a list of reports, you select a report, it connects to the InfoStore and retrieves the Report as the ReportSource to a CrystalReportViewer control
ie
Code:
CrystalViewer.ReportSource = RetrieveReportFromEnterprise(ReportID)Problem:
I need to be able to change the Database that the Report runs against at Runtime. Using just Crystal Reports this seems like a simple (relatively speaking) task, you load the report into a report object, iterate through the collection of tables in the report, and set the connection info for each table. I cannot seem to find an equivalent way to do this with CE though, there is no report object, there is just the viewer control. Does anyone have any ideas how to do this?