Print Page | Close Window

Adding multiple fields in a group

Printed From: Crystal Reports Book
Category: General Information
Forum Name: Self-Publishing
Forum Discription: Thinking about writing your own book or already have something to sell? Let me give you advice from my experiences.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22510
Printed Date: 03 Jul 2022 at 11:44am


Topic: Adding multiple fields in a group
Posted By: Anita0806
Subject: Adding multiple fields in a group
Date Posted: 14 Dec 2017 at 12:18pm
I have a SQL
Select Name,address,sum(salary)
from abc
group by name,address
How do I handle group by in Crystal



Replies:
Posted By: lockwelle
Date Posted: 02 Oct 2020 at 5:39am
I know that this is old, and for someone looking for the answer, the simplest way that comes to mind for me is to create a formula that concatenates the fields that you want to group on, and use that as the grouping condition.

There is probably other ways as well.

HTH



Print Page | Close Window