Results 1 to 3 of 3

Thread: data report + sql statement

  1. Sep 22nd, 2006, 04:21 AM #1
    heavenscent29
    heavenscent29 is offline

    Thread Starter
    Lively Member
    Join Date
    Aug 2006
    Posts
    88

    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
    Reply With Quote Reply With Quote
  2. Sep 22nd, 2006, 04:47 AM #2
    balajikandaswamy
    balajikandaswamy is offline
    Lively Member
    Join Date
    Jun 2006
    Location
    Chennai, India
    Posts
    87

    Re: data report + sql statement

    Why is there another post.

    see ur last post http://www.vbforums.com/showthread.php?t=429308
    Reply With Quote Reply With Quote
  3. Sep 22nd, 2006, 06:19 AM #3
    heavenscent29
    heavenscent29 is offline

    Thread Starter
    Lively Member
    Join Date
    Aug 2006
    Posts
    88

    Re: data report + sql statement

    pls refer to this

    http://vbforums.com/showthread.php?&...&is_resolved=1
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width