gixxer1020
asked on
Crystal Report Syntax for "include"
I have the following code but and on line 2 instead of looking for just "overbooked", I need any data that includes the word overbooked.
Date({Reservation.InDate}) in {?Date} and
{Room.RoomNumber} "overbooked" and
(IF {?Site} = 0 THEN TRUE ELSE {Reservation.SiteID} = {?Site}) and
{Reservation.ReservationSt atus} in ["Pending"]
Thanks,
Edwin
Date({Reservation.InDate})
{Room.RoomNumber} "overbooked" and
(IF {?Site} = 0 THEN TRUE ELSE {Reservation.SiteID} = {?Site}) and
{Reservation.ReservationSt
Thanks,
Edwin
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
FWIW, I think Peter's post deserves at least some of the points, since it's a valid solution. I was just providing some alternatives. You can ask to have the question re-opened and split the points between us, if you like.
James
James
and instr({Table field}, "overbooked") >0 and