Link to home
Get AccessLog in
Avatar of gixxer1020
gixxer1020Flag for United States of America

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.ReservationStatus} in ["Pending"]

Thanks,

Edwin
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

I don't know which field might contain 'overbooked' but the syntax you want is...


and instr({Table field},  "overbooked") >0  and
ASKER CERTIFIED SOLUTION
Avatar of James0628
James0628

Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
Avatar of James0628
James0628

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