vb query to crystal report

[noielen]

I have a problem with my report specifically the sql query that i been set to my crystal report file. In crystal report application works very fine but when i send an sql query going to it from vb, the output is not good.

Here's my goal.

1. I have a 2 tables, 1 table contains the header name and bottom name. 2nd table contain records for the body of the report which has an important records to be displayed.

1. I want to generate a report that displays detail calls to a particular extension, group by extension

Here's the Crystal Report Output and Sql query

SELECT
    CAS_CALL."EXTENSION",
    CAS_CALL."CALLDATE",
    CAS_CALL."CALLTIME",
    CAS_CALL."DURATION",
    CAS_CALL."DIALLEDNO",
    CAS_CALL."TYPEOFCALL",
    CAS_CALL."COST",
    CAS_CALL."ADDCOST",
    CAS_CONFIG."COMPADD",
    CAS_CONFIG."COMPEMAIL",
    CAS_CONFIG."CUSTOMTEXT"
FROM
    CASDB.dbo.CAS_CALL CAS_CALL INNER JOIN CASDB.dbo.CAS_CONFIG CAS_CONFIG ON
        CAS_CALL."STATUS" = CAS_CONFIG."STATUS"
ORDER BY
    CAS_CALL."EXTENSION" ASC

2nd image is the result from vb code query using this sql query below:

If Me.opt(0).Value = True Then
    strQry = " SELECT " & _
             " CAS_CALL.EXTENSION, CAS_CALL.CALLDATE, CAS_CALL.CALLTIME, CAS_CALL.DURATION, " & _
             " CAS_CALL.DIALLEDNO, CAS_CALL.TYPEOFCALL, CAS_CALL.COST, CAS_CALL.ADDCOST, CAS_CALL.STATUS, " & _
             " CAS_CONFIG.COMPADD, CAS_CONFIG.COMPEMAIL, CAS_CONFIG.CUSTOMTEXT " & _
             " From CAS_CALL INNER JOIN CAS_CONFIG ON CAS_CALL.STATUS = CAS_CONFIG.STATUS " & _
             " GROUP BY CAS_CALL.EXTENSION, CAS_CALL.CALLDATE, CAS_CALL.CALLTIME, CAS_CALL.DURATION, " & _
             " CAS_CALL.DIALLEDNO, CAS_CALL.TYPEOFCALL, CAS_CALL.COST, CAS_CALL.ADDCOST, CAS_CALL.STATUS, " & _
             " CAS_CONFIG.COMPADD, CAS_CONFIG.COMPEMAIL, CAS_CONFIG.CUSTOMTEXT " & _
             " HAVING (CAS_CALL.STATUS = 1) "
    strX = " Order By CAS_CALL.EXTENSION ASC "
    strReportFile = "extension all detail.rpt "
End If