Cache Report output

[cielo]

Where Can I delete the cache output in CA r6. When I just click on the report it is returning previous output and in edit mode it is returning proper output. Please help me . Ty.

[Lynn]

Where Can I delete the cache output in CA r6. When I just click on the report it is returning previous output and in edit mode it is returning proper output. Please help me . Ty.

It sounds like your report has a saved output and the default action is to display the latest saved output. I don't think the option to change the default action was available in R6 so you can "view versions" and delete the saved output or "run with options" to run without having to go to edit mode.

[cielo]

Thanks for your response. I have checked and there are no saved outputs .Still I am facing the issue

[Lynn]

Thanks for your response. I have checked and there are no saved outputs .Still I am facing the issue

Does the same problem occur if you use a different browser? Do other users have the same problem? What happens when you run with options instead of simply clicking on the report name?

[sreddy]

Hi Cielo,

I hope you found the answer.

If you didn't - when you select a Query, in Query properties under QUERY HINTS sections there is a option called Use Local Cache, you need to set that to NO. Cached data is not displayed in report output after modifying this property.

You need to modify this property to all the queries in the report.

Thanks !!