Hi. I got a table views to be viewed in crystalreport.

1) How do I control the formula field to select distinct
of the field in the section details?
@Contact
@CaseNo

2) it will be grouped by ID.


        ID Contact CaseNo
       -----------------------------------------

    S7801231 [email protected] CASE0001
    S7801231 [email protected] CASE0003
    S7801231 [email protected] CASE0004
    S7801231 62568425 CASE0001
    S7801231 62568425 CASE0003
    S7801231 62568425 CASE0004
    S7801231 62533807 CASE0001
    S7801231 62533807 CASE0003
    S7801231 62533807 CASE0004


Thanks.