Skip to Content
0
Former Member
Oct 15, 2012 at 09:44 PM

Crystal doesn't show correct values

13 Views

Hello.

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!