Link field appears as parameter field in RDC

winglan88
winglan88 used Ask the Experts™
on
I'm using RDC to run a Crystal report that contains a subreport.  Both the main report and the subreport run off of stored procedures that ask for parameter inputs.  All the fields and subreports are added through Crystal 8.5 and not dynamically through VB.  All I'm supplying on the VB side are the parameter values.  But when I try to supply the parameter values in VB, the RDC also asks for the value of the field that links the main report and the subreport together even though I already set the link field through Crystal 8.5.  Does anyone know how to override it?  Thanks.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
What code are you using to run the report?

Can you run the main report and the subreport independently to see which is asking for the extra parameter?

How are did you establish the link in CR8.5>

mlmcc

Author

Commented:
I just found out how it works.  Crystal automatically creates a parameter field in the subreport when a link field is assigned.  I just set the value of the link field parameter to {?Pm-StoredProcName;1.FieldName} in VB and it seems to work.  

Thanks.
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
Glad to help

mlmcc

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial