Report Sorting
Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
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=8897
Printed Date: 04 May 2025 at 6:28pm
Topic: Report Sorting
Posted By: O-tism
Subject: Report Sorting
Date 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 assist  thanx alot 
------------- If you're giving 110% to a task, it doesn't mean you're a hard worker, it means you're a mathematical idiot=) |
Replies:
Posted By: lockwelle
Date 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
|
Posted By: dpm1028
Date 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
|