Skip to Content
0
Jul 02, 2020 at 11:38 AM

TCRPE: How to change database name for a Crystal report v10 with multiple subreports

61 Views

We have an Delphi app that uses TCrpe object for Crystal Report v10 written for MS SQL Server Database. In Run-time, we need to connect the same report to different database depending on user's profile. The TCrpe help file says, we can change the TCrpe.Tables[i].TableName to include the database and owner details. However, it does not work, moreover, it seems report retains database name within the SQL of the report/subrports.

Did anyone come across this issue and know how to change database name of a report in run-time to connect to a different MS SQL server database than the report was designed with?

Any help would be appreciated.