Mungkin cara begini bisa diimplementasikan: 1. buat group username 2. buat group status 3. buat grand total untuk status dengan fungsi Count() atas status. 4. letakkan masing2 field di group footer / group header status 5. bagian detail di suppress serta bagian2 lain yang tidak dibutuhkan.
ok semoga membantu. rgds, Agus SA kislew_mm wrote: > 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... > > > > >
