Report shows different result than SQL query

[cslange]

I made a report showing only one column.
It shows a different result than when I run the SQL query in a query tool
The result from the query tool is the correct one.

When I put option 'Use Local Cache' to 'No', it does show the right result.

What goes wrong here?

[Francis aka khayman]

By default Cognos will store the output data of a report that was run in a cache. When you run the report again, Cognos will check the cache for report results and use that result. I do not know what conditions/criteria Cognos use to determine when to use cache data and when to retrieve a new set of data (same sql statement maybe... if somebody can confirm, great or you can search) .

Setting Use Local Cache = No will force Cognos to retrieve a fresh set of data everytime the report is ran.

[cslange]

Khayman, thank you for your quick reply.

The strange thing is that the first time I run the report it already goes wrong.
Therefore it looks like the report takes the result from a different report/query.

[nblank]

In the query properties "Auto Group & Summarize" is default "Yes". Perhaps chaging it to "No" helps?