Skip to Content
0
Former Member
Feb 24, 2009 at 10:42 AM

Sorting alphanumeric data within a range Crystal Reports 9 - Service Pack 7

84 Views

I have a report that uses a range (V300NI-PRINT - V300W6&12MTHOVERS) and when I extract the query using MS SQL profiler I run it and get the following return data

V300NI-PRINT

V300W-6&12MTH-PRINT

V300W-F/CVER 6&12MTH

V300W-PRINT

V300W6&12MTHOVERS

However, when the data is displayed in the report it only displays

V300NIPRINTu2019

V300W612MTHOVERS

the other 3 records have disappeared, which is clearly incorrect as I want to see all 5 records. It seems that some sort of client side filtering is being done and at a guess it looks as if the '-' characters are being removed and the sort is then becoming:-

V300NIPRINT

V300W612MTHOVERS

V300W612MTHPRINT

V300WFCVER612MTH

V300WPRINT

The range would then return the top 2 records which is consistent with the result I have seen.

Also, if I replace the '-' with a '' the results are expected. As these are product codes I can't really replace a '-' with a '' so I've got a suspicion that I'm missing something obvious or i'm on the wrong track entirely hence the post. However, I'm a Crystal Reports Novice so any advice, ideas, suggestions would be gratefully received.