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
However, when the data is displayed in the report it only displays
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:-
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.