Passing value from main report to subreport

[Yudi]

Hi All

I use CR XI with MySql V5.0

I have a report with 2 subreports which are placed in detail section of main report. the record in sub report will be selected according to the value of 'CustCode' field in detail section of main report.

I have created a parameter field in both subreport called 'CustCode' and linking 'custcode' field in detail section of main report to those parameters.

but, this way still result in error.

mysql odbc said that "...unknown field name 'XXXXX' in where clause..", where 'XXXXX' is the value of 'CustCode' field in detail section of main report.

I have tested the stored proc. separately, and no error found. Please help me