Results 1 to 3 of 3

Thread: Group by multiple fields

  1. #1

    Thread Starter
    Hyperactive Member Petergotchi's Avatar
    Join Date
    Jan 2002
    Location
    Dendermonde - Belgium
    Posts
    267

    Smile Group by multiple fields

    I want to group by two fields. I can't seem to get it to work. This is the code I have:
    Code:
    SHAPE{SELECT TblUsers.UserName,TblTimeTable.LogInDate,TblTimeTable.LogInTime,TblTimeTable.LogOutDate,TblTimeTable.LogOutTime,TblTimeTable.SessionName FROM TblTimeTable INNER JOIN TblUsers ON TblTimeTable.UserID = TblUsers.UserID WHERE TblTimeTable.LogInDate BETWEEN #" & Format(strFromDate, "mm/d/yyyy") & "# AND #" & Format(strToDate, "mm/d/yyyy") & "# ORDER BY [TblUsers.UserName],[TblTimeTable.SessionName]}" & "AS SQL1 COMPUTE SQL1 BY UserName,SessionName"
    Error message I get is "Report Sections do not match data source"

    It's probably something very easy, but I can't seem to figure out what it is... I'm a complete newbie in using report designers... Your help is appreciated! ;-)
    Kind Regards,

    Pieter

    PS: If you found someone's answer helpful, please be so kind to rate that person.
    Thanks.

  2. #2

    Thread Starter
    Hyperactive Member Petergotchi's Avatar
    Join Date
    Jan 2002
    Location
    Dendermonde - Belgium
    Posts
    267

    Re: Group by multiple fields

    Anyone got an idea? Or do you need more information?
    Kind Regards,

    Pieter

    PS: If you found someone's answer helpful, please be so kind to rate that person.
    Thanks.

  3. #3
    Frenzied Member
    Join Date
    Aug 2006
    Location
    India, Punjab, Bhatinda
    Posts
    1,689

    Re: Group by multiple fields

    it appears from the err msg the fields in the report is not available in the actual tables/ or in the datasource you created. Check the fields again...

Posting Permissions

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



Click Here to Expand Forum to Full Width