Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

Multiple Groups

edited April 2009 in General
Is there a way to have multiple groups? I have a recordset with names,
dates, and account. What I would like to do is group by name, and then
group by date by name. So in a format like the following:

John Doe
01/01/2009 $100
01/02/2009 $200
Jane Doe
01/01/2009 $150
01/01/2009 $330

My recordset looks like as follows:
John Doe 01/01/2009 $50
John Doe 01/01/2009 $50
John Doe 01/02/2009 $50
John Doe 01/02/2009 $50
John Doe 01/02/2009 $100
Jane Doe 01/01/2009 $50
Jane Doe 01/01/2009 $50
Jane Doe 01/02/2009 $300
Jane Doe 01/02/2009 $30

Any suggestions would be greatly appreciated.

-StinkyDuck

Comments

  • edited April 2009
    pretty easy--open up the report editor, and select 'Report/Groups' from the
    main menu--add the group by the field name for the client.

    HTH,

    Ed Dressel
    Team DM

  • edited April 2009
    I figured it was this easy but I overlooked the INSERT button. Idiot. I
    was under the assumption that you could only have one group. Thanks!


This discussion has been closed.