Data Designer: Unable to group (newbie question)

[Petergotchi]

Hi,

I'm new to building reports. I've gotten to a point where I want to group the results, but can't seem to figure out how it works. I've spent 2 hours searching on this and can't seem to get it to work.

This is what I got so far:

I've read that I need to use Shape. So I altered my SQL command to the following:

"SHAPE{SELECT UserName,LogInDate,LogInTime,LogOutDate,LogOutTime FROM " & strTable & " WHERE LogInDate BETWEEN #" & strFromDate & "# AND #" & strToDate & "# ORDER BY [UserName]}" & "AS SQL1 COMPUTE SQL1 BY UserName"

And defined the fields in my code like that:

    DataReport1.Sections("section1").Controls.Item("Text1").DataField = "LogInDate"
    DataReport1.Sections("section1").Controls.Item("Text1").DataMember = "SQL1"
    DataReport1.Sections("section1").Controls.Item("Text2").DataField = "LogInTime"
    DataReport1.Sections("section1").Controls.Item("Text2").DataMember = "SQL1"
    DataReport1.Sections("section1").Controls.Item("Text3").DataField = "LogOutDate"
    DataReport1.Sections("section1").Controls.Item("Text3").DataMember = "SQL1"
    DataReport1.Sections("section1").Controls.Item("Text4").DataField = "LogOutTime"
    DataReport1.Sections("section1").Controls.Item("Text4").DataMember = "SQL1"
    DataReport1.Sections("section1").Controls.Item("Text5").DataField = "UserName"
    DataReport1.Sections("section1").Controls.Item("Text5").DataMember = "SQL1"

This generates the following report:

Username:       Login Date:    Login Time:       Logout Date:   Logout Time:

User             5/02/2008      13:30:00           5/02/2008     16:00:00
User             5/02/2008      7:00:00            5/02/2008     12:00:00
User             2/02/2008      9:00:00            2/02/2008     17:00:00
User2            4/02/2008      10:00:00           4/02/2008     18:00:00
User3            3/02/2008      8:30:00            3/02/2008     16:30:00

But what I really want is to group the times per username. How can I do this? Thanks for your guidance.

PS: I'm using the classic VB6

[brucevde]

Right-Click in any section within the data report and select the Insert Group Header/Footer menu item.
Add a TextBox control into the new Group Section and set it's DataField property to UserName. It's DataMember property must be left empty.

[Petergotchi]

Hi,

Great! Worked like a charm. I already had a group header in but it wouldn't work because I didn't leave the datamember field empty!
Thanks m8! Can't believe I was struggling with this for so long... :-)