When doing a Set Data Source Location of the main report and subreport the owner name is not changed for subreport.
Subreport still points to old owner after changing the data source.
- Crystal Reports 2008
- MS SQL Server 2008
Reproducing the Issue
Create a report with a subreport based on the same SQL Server connection.
Change the data source of the main report by going to Database tab.
Select Set Data Source Location…
Select the connection name under Current Data Source
Create the new connection under Replace with
Click on Update.
The connection for main report and subreport is updated.
- On expanding the connection for the subreport the Owner Name is not changed.
Update the connection for the main report first and then select the connection under subreport in Current Data Source and then update the connection for the subreport individually.
Owner name not changed, set data source fails to update , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem