Hi,
I am able to pass single parameter from MS Access to Crystal reports, does any one know, how to add other parameter, I have tried to add Pacct as in the following code, but don't know the exact syntax. thanks for you help.
Private Sub CmdStatusRpt_click()
Dim pdate As String
Dim pacct As String
pdate = Forms![crystal report]![LstDate]
pacct = Forms![crystal report]![lstAcct]
StatusReport.ReportFileName = "C:\performance\composite failed.rpt"
StatusReport.ParameterFields(0) = ("pdate;composite failed;true"
StatusReport.Action = 1
End Sub
Tanvir
I am able to pass single parameter from MS Access to Crystal reports, does any one know, how to add other parameter, I have tried to add Pacct as in the following code, but don't know the exact syntax. thanks for you help.
Private Sub CmdStatusRpt_click()
Dim pdate As String
Dim pacct As String
pdate = Forms![crystal report]![LstDate]
pacct = Forms![crystal report]![lstAcct]
StatusReport.ReportFileName = "C:\performance\composite failed.rpt"
StatusReport.ParameterFields(0) = ("pdate;composite failed;true"
StatusReport.Action = 1
End Sub
Tanvir