Crystal Reports Group by one field sort by another

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions

Topic: Group by one field sort by another

Author	Message
jrhodes Newbie Joined: 08 Jun 2010 Online Status: Offline Posts: 9	Topic: Group by one field sort by another 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.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	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
	IP Logged

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.031 seconds.