cancel
Showing results for 
Search instead for 
Did you mean: 

How to group by more than one fields in crystal reports

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (0)