Hi Mariette

This is an issue in the way I setup the caching and I am working to fix it. You can clear the cache manually by going to the Module Settings and just pressing Update without changing any settings (this forces the cache to be cleared). That is one workaround but probably not quite what you are looking for. My first priority on the Module right now is implementing a setting that will allow you to disable caching completely so hopefully this issue will be fixed quickly.

However, as a short-term workaround and if you are ok with diving into the code a bit, I can show you which line to change to disable caching in the code. However, this has NOT been tested fully and the changes will affect all Reports modules in your site, so I recommend backing up the relevant file first.

In App_Code/Reports/ReportsController.vb at line 145 in ExecuteReport
Replace this line: Dim objCache As Object = DataCache.GetCache(strCacheKey)
With this line: Dim objCache As Object = Nothing

This will force the system to execute your query every time, completely bypassing the cache.

Hope that helps, and there should be a proper fix for this issue soon!

---

Andrew Nurse
DotNetNuke Core Team Member and Reports Module Project Lead
Microsoft Certified Professional Developer