Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports .NET 2003 : Report Design
Message Icon Topic: Report Sorting Post Reply Post New Topic
Author Message
O-tism
Newbie
Newbie
Avatar

Joined: 18 Jan 2010
Location: South Africa
Online Status: Offline
Posts: 1
Quote O-tism Replybullet Topic: Report Sorting
    Posted: 18 Jan 2010 at 3:21am
Hi,

Can someone please help me, this is very urgent.
I need to create a report that has a formula field in combining a quote number and a quote line but now if i put a sort in it sorts the quote number correctly but not the lines. for e.g if it has more than 10 lines it sorts it as follow
quote1 - 1
quote1 - 10
quote1 - 2
quote1 - 3
and so forth...

what i gathered is that i need to somehow sort 2 characters and not one

please assistQuestion

thanx alotSmile
If you're giving 110% to a task, it doesn't mean you're a hard worker, it means you're a mathematical idiot=)
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 19 Jan 2010 at 6:50am
since this is doing an alphanumeric sort, you will need to pad the numbers with correct number of '0' on the left, if you have 100 lines of quotes you will need to add 2 zero in some cases and 1 in most.  The hard part is know how many zeros to add.
 
You might try sorting on a date field (if it exists) as I would assume (I know, silly me) that the quotes would be in order of creation.
 
HTH
IP IP Logged
dpm1028
Newbie
Newbie


Joined: 04 Feb 2010
Online Status: Offline
Posts: 12
Quote dpm1028 Replybullet Posted: 04 Feb 2010 at 3:05pm
Hi,
I am having the same issue.  I tried padding the entries with zeroes but got the same results.  I set the table column to be both text and numeric.  Did this solution work for you?
 
Thanks, dpm1028
IP 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.016 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.