Unfortunately, when you try to obfuscate what is considered non-essential parts of a query, you often end up with a totally different issue.   I'm fairly certain that there's some other problem with what is being done.   I suspect that the Crystal Report has it's own grouping somewhere in the report or something else that is inherent to the report, such as accidentally choosing the same column twice.   Or perhaps not realizing that you didn't place one of those two columns in the report, and thus only got one in the results.   You have to be sure the second column is actually in the report somewhere, and on the same detail line as the other column (at least most of the time, this is how you typically do that)...