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.