saya punya table "tbl_data_respondent" username | status | alamat ===================================== AMEL | MOVE OUT | JL .X AMEL | MOVE OUT | JL. Y ANA | WRONG NUMBER | JX .B ANA | WRONG NUMBER | JL. C ANA | WRONG NUMBER | JL. SSS ANA | DECLINE | JL. ABC ANA | DECLINE | JL. B ANA | DECLINE | JL. X ANA | DECLINE | JL. Y
pengen hasil tampilnya gini , tapi di Crystal Report : USERNAME | STATUS | TOTAL =================================== AMEL | MOVED OUT | 2 ANA | WRONG NUMBER | 3 ANA | DECLINE | 4 KLO di SQL SERVER gampang tinggal query gini aja..: SELECT USERNAME, STATUS, COUNT(USERNAME) AS TOTAL FROM TBL_DATA_RESPONDENT GROUP BY USERNAME, STATUS ORDER BY USERNAME, STATUS bingung nich...gimana sih di Crystal Reportnya ??? apa tetep ambil table TBL_DATA_RESPONDENT nya aja secara keseluruhan. trus apa yg di group , apa yg filter ?.. pake klik report expert nya gimana ?? tolong donk...
