Reports Modules - Renderers, Caching and Parameters!

andrew@openarrow.com — Mon, 14 Aug 2006 04:00:00 GMT

So, It's been a little while since I blogged, but thats because I've been working on an exciting new feature for Reports. I call them "Report Renderers".

Reports Module...What to do next?

andrew@openarrow.com — Mon, 17 Jul 2006 08:00:00 GMT

Recently, I've been bug fixing on the Reports module (see my previous post Re: Caching Workaround and the Reports Project Fourms). Now that most of those issues are fixed, its time to look at new features!

Caching workaround for Reports Module

andrew@openarrow.com — Sun, 09 Jul 2006 08:00:00 GMT

One of the features I'm working on in the next version of Reports (actually its more of a bug fix) is to provide Administrators with the ability to disable Caching and set a Cache Timeout. Right now the module caches the results of a report with no time out, and the only way to clear the cache is to open the Module Settings and press Update which clears the cache. This has caused problems for some users so the new version should fix those problems.

In the mean time, I have a one-liner code fix for anyone who wants to disable caching completely. WARNING: This has not undergone rigorous testing and you should create a backup copy of the relevant file just to be safe. Also, this change will affect all Reports modules on all Portals using the same codebase. Having said that, I've had no issues and it seems to disable caching properly. Here's the change:

In App_Code/Reports/ReportsController.vb at line 145, replace the following line:
Dim objCache As Object = DataCache.GetCache(strCacheKey)
With this text:
Dim objCache As Object = Nothing

This forces the module to execute the report in every request and bypasses caching. There may be a performance penalty, but if you are having problems because of caching this is a short-term workaround that should help, at least until the new version is ready.

Module :: Reports

Reports Modules - Renderers, Caching and Parameters!

Reports Module...What to do next?

Caching workaround for Reports Module