Print Page | Close Window

Group by one field sort by another

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=11379
Printed Date: 18 May 2024 at 9:11pm


Topic: Group by one field sort by another
Posted By: jrhodes
Subject: Group by one field sort by another
Date Posted: 10 Oct 2010 at 12:39pm
Hi,

Is it possible to Group on one field but then sort the groups on another?

I have a group of "Projects" and I want to group them by their "Project ID" but then have the report sort the groups in Alphabetical order based on the "Project Title".

Is this possible? Thanks.


Replies:
Posted By: DBlank
Date Posted: 11 Oct 2010 at 4:28am
create a formula field to add teh two items together
name + '-' + ID
if it is numeric id
name + '-' + totext(id,0,'')
group on this
hide the group header
display the group name field in the group header


Print Page | Close Window