Passing a field value to a stored procedure parameter 1

[MaryValles]

I am using Crystal 8.5 Professional. Data is stored in SQL Server 2000. I have a main report that has customer number. I need to pass the value of customer number to the subreports stored procedure parameter. How can I do this?

 

[GMcNamara]

Link the customer number from the main report to the stored procedure parameter in the subreport.

 

[MaryValles]

How do I do that? The stored procedure parameter doesn't show up in the list of fields to link.

 

[GMcNamara]

Make sure the customer number from the main report is the same data type as the parameter in the subreport. When you select the main report field to link, only fields of the identical data type appear in the fields to link to list.

 

[MaryValles]

The datatypes are the same. For instance, if I inlude the parameter in the select statement (i.e. @AccountInputNumber AS AccInputNo) it appears in the list for available fields to link to. The fieldname (@AccountInputNumber) that is under the parameters section in subreport does not show up in the list.

 

[ejanakieff]

Hello.

I have the same problem.
Can you get finnaly the solution?

Thanks,
Eva Janakieff