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.