Data Connectivity
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Data Connectivity
Message Icon Topic: Sub Report Link Problem Post Reply Post New Topic
Author Message
nbalajicec
Newbie
Newbie


Joined: 19 Sep 2007
Online Status: Offline
Posts: 10
Quote nbalajicec Replybullet Topic: Sub Report Link Problem
    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 ?
IP IP Logged
jkwrpc
Senior Member
Senior Member


Joined: 19 Jun 2007
Location: United States
Online Status: Offline
Posts: 432
Quote jkwrpc Replybullet 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.
 
IP IP Logged
nbalajicec
Newbie
Newbie


Joined: 19 Sep 2007
Online Status: Offline
Posts: 10
Quote nbalajicec Replybullet Posted: 24 Sep 2007 at 9:10pm

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

IP IP Logged
jkwrpc
Senior Member
Senior Member


Joined: 19 Jun 2007
Location: United States
Online Status: Offline
Posts: 432
Quote jkwrpc Replybullet 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.
IP IP Logged
nbalajicec
Newbie
Newbie


Joined: 19 Sep 2007
Online Status: Offline
Posts: 10
Quote nbalajicec Replybullet 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..
 
 
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.014 seconds.