Print Page | Close Window

Sort By Formula Field

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=19668
Printed Date: 29 Apr 2024 at 11:48pm


Topic: Sort By Formula Field
Posted By: Steginman
Subject: Sort By Formula Field
Date Posted: 17 Jun 2013 at 10:48am
I have a formula field being using as a group by. The formula is
 
{load_item.order_id} + " - " + totext({load_item.item_num},0)
 
 
The Result of this group by is
 
123-1
123-12
123-13
123-5
 
How can I get the report to group by this:
 
123-1
123-5
123-12
123-13
 


Replies:
Posted By: DBlank
Date Posted: 17 Jun 2013 at 12:19pm
you would have to format your totext to use "00".
You can always use that for grouping and sorting but use a different result for display.
 
totext({load_item.item_num},"00",0)

Posted By: Steginman
Date Posted: 18 Jun 2013 at 3:32am
Thanks Dblank, that did the trick


Print Page | Close Window