数据源为带参数的存储过程的水晶报表,vc6 MFC怎么传递参数?
数据源为一个存储过程,需要2个输入参数@date1 @date2
mfc中到底用哪个函数将变量传入参数?
SetReportVariableValue 还是什么?
[解决办法]
我的这部分代码是VB的,看看有没有帮助
With crxRpt
For Each crxParamDef In .ParameterFields
With crxParamDef
Select Case .Name
Case "{?p_bill_ref}"
.ClearCurrentValueAndRange
If BillRef >= 256 And ((BillRef Mod 256) = 0) Then
.AddCurrentValue (BillRef + CrystalFudge)
Else
.AddCurrentValue (BillRef)
End If
Case "{?p_addr_type_code}"
.ClearCurrentValueAndRange
.AddCurrentValue (BillAddressTypeCode)
Case "{?p_use_supp}"
.ClearCurrentValueAndRange
.AddCurrentValue (cstYesFlag)
Case "{?resume_flg}"
.ClearCurrentValueAndRange
.AddCurrentValue (cstYesFlag)
End Select
End With
Next
[解决办法]
SetParameterValue