Print Page | Close Window

Sub Report Link Problem

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=1369
Printed Date: 06 May 2024 at 4:08am


Topic: Sub Report Link Problem
Posted By: nbalajicec
Subject: Sub Report Link Problem
Date Posted: 24 Sep 2007 at 5:38am

Hi,

I've a problem with my subreports parameters at runtime ! I developped report on my developpment Server (Oracle 10G). This report contains three subreports ! Im getting the main report  parameters by runtime and it's work perfectly. The problem is when i change my server name at runtime (production). Parameters in the main report are initialized correctly, but it is prompting parameters for all  the subreport parameters.

Information : All parameters in subreports exists on the main report and they are linked !

I don't understand the problem, two days spent on Internet forums, but i didn't found !

It does as if the link has been broken !

I try to initalize all parameters, explicitely, (main report and subreports) : same problem !

I try to initialize subreports parameters first and in this case, all subreports parameters were initialized, but it displays to me the prompt parameters for all main report parameters !

This happens only we change the Link.. Is there is any way to retain the Link between Sub Report and Main Report..
 
Can anyone help me ?


Replies:
Posted By: jkwrpc
Date Posted: 24 Sep 2007 at 10:48am
Are you making sure you have changed the server location for each of the subreports in addition to the main report.?
 
Regards,
 
John W.
http://www.CustomReportWriters.net - www.CustomReportWriters.net
 

Posted By: nbalajicec
Date Posted: 24 Sep 2007 at 9:10pm

Yes of Course, Im Changing the servername for all the sub reports..

Posted By: jkwrpc
Date Posted: 25 Sep 2007 at 9:02am

You always hope for the easy stuff.

Do the subreports connect to the same tables as the main report. If not is there the possibility of a permissions problem on the production server?
 
Yes, still trying the easy stuff. But if it works in one in environment and not the other it is likely in the connections and permissions.
 
 
Regards,
 
John W.
http://www.CrystalReports.net - www.CrystalReports.net  

Posted By: nbalajicec
Date Posted: 27 Sep 2007 at 3:17am
No for subreports  im assigning the seperate procedures..
im giving the input for the sub report from main report values..
 
Dynamically i changed the database name and its working fine..
for that im using verifydatabase(). After changing database the link between subreport and main report is getting disconnected.. i dont know why..
 
 


Print Page | Close Window