Linking Using a formula

[gazza11]

I have asked the question in Crystal Data Access forum of how to pass a parameter from VB to a Crystal report that is embedded in VB (ie dsr).
It does not look as though anyone is familiar with the way of doing this and my requirement is now urgent.

In summary I have a sub report that is linked to a main report parameter field and instead of getting asked for the number (as happens corretly), I want to pass it automatically. Since I can use VB to write my number (EmployID) into a text box on the main form (or sub report) I was wondering whether anyone can help me with a formula to get the sub report to use this value to select data on.

 

[synapsevampire]

If the subreport is linked to the Main report based on that field, it will use whatever you pass to the main report parm.

It's a good idea to post the version of Crystal and VB as there are different means depending upon versions.

Here's some generic info on VB and parms:

http://www.crystalkeen.com/articles/crystalreports/parametersandvb.htm

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[IdoMillet]

The correct approach for your situation is to pass the value from VB into a main report Parameter (NOT into a text box).

Then pass that parameter value into the linked subreport.

Cheers,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[gazza11]

Thanks for the help. I am using CR 8.5. I acknowledge that the best way is to pass the parameter but that is what I am having trouble doing. In my VB code I used CRObject.parameterfields.count (where CRobject is my report) and it showed I had 2 parameters which is correct but I am only using 1.
I have a variable (number) iCurrentEmployeeID that I am trying to pass as a parameter. I used CRobject.parameterfields(0) = "iCurrentEmployeeID;0;true" but it gives me a subscript out of range error.