Hi, I have a strange behaviour in one of my reports:
The query that runs behind this report returns results normally, however on report we see nulls in these columns. To make it even stranger, this only happens on some rows, not all.
To give an example (obviously the report in question is a bit more complex)
CityID
| CityID | CityName
| Count of Employees |
|---|
| 1 | Moscow | 20 |
| 2 | London | 10 |
| 3 | New York | 40 |
| 4 | Berlin | (null here) |
The query that I get from session logs returns Count of Employes for Berlin = 50. So why is null displayed here?
To add to this, if I filter the report in the prompt to CityID = 4, so that only the row with Berlin is displayed, I get the correct Count of Employees!
| CityID | CityName | Count of Employees |
|---|
| 4 | Berlin | 50 |
If I check the query again, it is identical except for 'where CityID = 4' condition added to it.
What could be causing this strange behaviour?
Thanks and regards,
kzane