joshidharmesh
Programmer
Hi,
Can I pass multiple selection parameters when calling a crystal report? I am writing following lines
Private Sub PrintTicket(Sr_No As Integer, Class As String, Show As String)
With Form1.Ticket
.DataFiles(0) = App.Path & "\Database\MPlex.mdb"
.ReportFileName = App.Path & "\Reports\Ticket.rpt"
.SelectionFormula = "{Booking.SrNo} = " & Sr_No & " & "{Booking.Class} = " & class &" & "{Booking.ShowName} = " & show &""
.UserName = "Admin"
.Password = "n44d931" & Chr(10) & "n44d931"
.Action = 1
End With
End Sub
I am getting error "Invalid character" with { of {Booking.Class}
Can someone help?
Thanks
Dharmesh Joshi
Can I pass multiple selection parameters when calling a crystal report? I am writing following lines
Private Sub PrintTicket(Sr_No As Integer, Class As String, Show As String)
With Form1.Ticket
.DataFiles(0) = App.Path & "\Database\MPlex.mdb"
.ReportFileName = App.Path & "\Reports\Ticket.rpt"
.SelectionFormula = "{Booking.SrNo} = " & Sr_No & " & "{Booking.Class} = " & class &" & "{Booking.ShowName} = " & show &""
.UserName = "Admin"
.Password = "n44d931" & Chr(10) & "n44d931"
.Action = 1
End With
End Sub
I am getting error "Invalid character" with { of {Booking.Class}
Can someone help?
Thanks
Dharmesh Joshi