Skip to Content
author's profile photo
Former Member

How to group by more than one fields in crystal reports

Hi

How to create groups in crystal reports by more than one fields, like

select fields,aggregate functions from table group by a,b,c

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    author's profile photo
    Former Member
    Posted on Oct 02, 2007 at 12:20 AM

    Not sure if I understand your question, but you you could create a formula to generate the string of data you want to group on. Then simply create a group based on the formula field.

    For example, your formula could do something like (assuming all String fields):

    {table1.FirstName} + {table1.LastName} + {table1.DateOfBirth}

    , and then group on this formula.

    -MJ

    Add comment
    10|10000 characters needed characters exceeded