INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Selecting multiple fields in Crystal report

Selecting multiple fields in Crystal report

(OP)
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

RE: Selecting multiple fields in Crystal report

You are missing the word AND between the criteria. Try something like this:

"{Booking.SrNo} = " & Sr_No & " and {Booking.Class} = " & class &" and {Booking.ShowName} = " & show &""

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks
http://www.kenhamady.com/

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close