Crystal Reports Sort By Formula Field

Data Connectivity
Crystal Reports Forum : Crystal Reports 9 through 2020 : Data Connectivity

Topic: Sort By Formula Field

Author	Message
Steginman Newbie Joined: 17 Jun 2013 Online Status: Offline Posts: 2	Topic: Sort By Formula Field 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
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	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) Edited by DBlank - 17 Jun 2013 at 12:20pm
	IP Logged

Steginman Newbie Joined: 17 Jun 2013 Online Status: Offline Posts: 2	Posted: 18 Jun 2013 at 3:32am
	Thanks Dblank, that did the trick
	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.