Result not displaying in crystall report where sql query works in sql server..?

See more:

C#

VB

SQL-Server-2008R2

Dim prdate As Date = Format(Check_Date.Value, "dd/MM/yyyy")
        cmd.CommandText = "SELECT MAINFILE.facno, MAX(MAINTRAN.fdate) AS fdate, MAINTRAN.fbalance FROM MAINTRAN INNER JOIN MAINFILE ON MAINFILE.facno = MAINTRAN.facno where MAINTRAN.fdate<='" & Format(prdate, "MM/dd/yyyy") & "' GROUP BY MAINFILE.facno, MAINTRAN.fbalance  "

                              
        With cmd
            dr = .ExecuteReader
        End With

        If dr.HasRows = True Then
            Do While dr.Read
                presentdaybal = dr!fbalance
            Loop
            dr.Close()       

its working fine ...
then when i display:facno(from mainfile table) fblance fdate(these two fields from MAINTRAN )
these fields are blank...why?