Crystal Reports Customer sort

Report Design
Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design

Topic: Customer sort

Author	Message
crystal2012 Newbie Joined: 17 Apr 2012 Online Status: Offline Posts: 36	Topic: Customer sort Posted: 21 May 2012 at 11:04am
	The report has a group defined as string. the report needs to be sort in asc alphabetical order except one group needs always list in the first group. Is there easy way to create custom sort formula to avoid create a extra sort field in sql? Thanks!
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 22 May 2012 at 4:00am
	I would just create a formula field that has the sorting you want, group on it but use the orignal field for display if {table.NAME}='one off' then ' one off' else {table.NAME}
	IP Logged

crystal2012 Newbie Joined: 17 Apr 2012 Online Status: Offline Posts: 36	Posted: 25 May 2012 at 2:29am
	Got it. Thanks!
	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.