Print Page | Close Window

Customer sort

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=16501
Printed Date: 17 May 2024 at 10:31pm


Topic: Customer sort
Posted By: crystal2012
Subject: Customer sort
Date 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!


Replies:
Posted By: DBlank
Date 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}

Posted By: crystal2012
Date Posted: 25 May 2012 at 2:29am
Got it. Thanks!


Print Page | Close Window