I am using the following select statement in SSRS 2205. I am wondering why all RACES not being grouped?SELECT DISTINCT CCOC_Intake_Eligibility.patient_ID, CCOC_Intake_Eligibility.race, COUNT(CCOC_Intake_Eligibility.race) AS CountRaceFROM CCOC_Intake_Eligibility, CCPP_ScreenResultsWHERE CCOC_Intake_Eligibility.patient_ID = CCPP_ScreenResults.patient_ID AND (NOT (CCPP_ScreenResults.screeningTest LIKE 'No Show')) AND (CCOC_Intake_Eligibility.colonoscopyScheduledDate >= ?) AND (CCOC_Intake_Eligibility.colonoscopyScheduledDate <= ?)GROUP BY CCOC_Intake_Eligibility.race
This is my a sample of the output.69 Black 144530 Other NULL531 Other NULL553 Other NULL606 Other NULL611 Other NULL618 Other NULL625 Other NULL634 Other NULL646 Other NULL559 Unknown NULL679 Unknown NULL710 Unknown NULL742 Unknown NULL747 Unknown NULL462 White NULL500 White NULL501 White NULL504 White NULL514 White NULL519 White NULL539 White NULL543 White NULL544 White NULL550 White NULL551 White NULL554 White NULL561 White NULL566 White NULL569 White NULL572 White NULL574 White NULL575 White NULL577 White NULL578 White NULL581 White NULL589 White NULL592 White NULL594 White NULL595 White NULL596 White NULL597 White NULL598 White NULL600 White NULL602 White NULL603 White NULL605 White NULL609 White NULL613 White NULL617 White NULL626 White NULL635 White NULL639 White NULL648 White NULL649 White NULL651 White NULL652 White NULL654 White NULL663 White NULL664 White NULL665 White NULL673 White NULL674 White NULL690 White NULL696 White NULL699 White NULL700 White NULL702 White NULL704 White NULL705 White NULL708 White NULL709 White NULL715 White NULL716 White NULL717 White NULL720 White NULL723 White NULL724 White NULL726 White NULL727 White NULL729 White NULL734 White NULL
not grouping
Posted - 2010-03-09 : 15:46:56
