I am trying to create a sql expression field but I keep getting a syntax error on the select statement, code below:
SELECT COUNT(Booking."PersonID") From Booking INNER JOIN Event ON Booking."EventID" = Event."EventID"
Otherwise, is there any other way around this, below is what I am trying to achieve:
I am using 2 sql tables - Event and Bookings. There are many bookings to an event, I am currently listing in the report all the available events, but for each record I
want to show how many bookings have been made on each event and the way this is done is by counting each booking record in the booking table which has the eventID of the event.. Applying this in SQL is simple:
SELECT COUNT(*) From Booking INNER JOIN Event ON
Booking.EventID = Event.EventID
GROUP BY EVENTID
I just can't seem to apply it to Crystal. I have Crystal Reports 7.