I have a graph that isnt displaying as much of a category(group) as it should.

so i take a look at the sql query, copy it, and run it in my datasource (ms access) to see if its getting all the records it should be getting.

in access it returns 976 records. (including my rows that arent turning up on the report)

and in crystal it says it only has 723 records!

here is the sql in case anyone is interested:

SELECT `SeasonTicketType`.`TicketTypeID`, `SeasonTicketType`.`TicketName`, `SeasonSeat`.`Bay`, `SeasonTicket`.`SeasonID`, `SeatStatus`.`SeatID`, `SeatStatus`.`Status`
FROM ((`SeasonSeat` `SeasonSeat` LEFT OUTER JOIN `SeasonTicket` `SeasonTicket` ON `SeasonSeat`.`SeatID`=`SeasonTicket`.`SeatID`) INNER JOIN `SeatStatus` `SeatStatus` ON `SeasonSeat`.`SeatID`=`SeatStatus`.`SeatID`) LEFT OUTER JOIN `SeasonTicketType` `SeasonTicketType` ON `SeasonTicket`.`TicketTypeID`=`SeasonTicketType`.`TicketTypeID`
WHERE `SeasonSeat`.`Bay`='12' AND (`SeasonTicket`.`SeasonID`=2 OR `SeasonTicket`.`SeasonID` IS NULL )

So i KNOW that ms acces is giving the right records, but why isnt Crystal processing all of them?

any tips on what to check?