data report + sql statement

i created a data report. i grouped them by address using the properties of command1 in the data environment (meaning not using sql statement). it runs okay. but when i added sql statement on the properties also of command1, an error appears 'datafield 'command1.lname' not found

SELECT STUD_NO, LNAME +','+ FNAME +' '+ MNAME AS STUD_NAME, ADDRESS, AGE FROM TBLSTUDENT

Why is there another post.

see ur last post http://www.vbforums.com/showthread.php?t=429308

pls refer to this

http://vbforums.com/showthread.php?&...&is_resolved=1