I'm using this sentence in my query to only count as 1 time when a value in a certain column repeats:
Case Row_Number() Over(Partition BY T0.U_CR ORDER BY T0.U_CR) When 1 then 1 else 0 End Conteo,
so for example, if the value in the column U_CR repeats three times, this will create another column named Conteo and in the first value it will show the value 1 and in the other 2 repeated values it will show 0, so it will only count it as 1. This works flawless in SQL Server, but when I move it to crystal it sometimes works good and sometimes don't, when I group some values in some groups it shows it fine but in some it just doesn't, any idea why's happening this?
Thanks in advance!