I am having trouble keeping parameter links between the main report and its sub reports.
I am developing with C# VS 2005, VS 2005 Crystal Reports and SQL Server 2000.
I have several reports (with embedded sub reports) that pass values to different SPROCS in SQL server.
One Report has three sub reports. The Main report and all three sub reports are linked to different stored procedures but pass the same parameters to their respective SPROC. My C# App passes params to the main report. The main report then passes appropriate params on to each sub report. The main report and sub reports pass appropriate params on to their stored procedures.
This all works great until I Reset the DataSource location to a copy of the same database (Same exact Stored Procedures). After doing this, the link is broken for Parameters between the main report and sub reports. I am unable to re-establish the link. I do this by going to Change Subreport links, choose the main report params and designate the sub report parms, choosing the subreports @ params not PM params.
Does anyone see what might be happening here??