Yes, that should resolve the issue, at least for the CreateDate field. So, if you change the line in FormatRemoveSQL (in ReportsController.vb) that reads:

Dim BadSQL As String() = New String() {";", "--", "create", "drop", "insert", "delete", "update", "sp_", "xp_"}

to:

Dim BadSQL As String() = New String() {";", "--", "drop", "insert", "delete", "update", "sp_", "xp_"}

or even:

Dim BadSQL As String() = New String() {}

The problem should be resolved. The latter solution disables all of the filters as opposed to just the one for the "create" command, you could also use a combination by just removing the 'create' one for now and others as you need to.

These solutions have not been fully tested and the next release will fix this issue.

---

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

Andrew, thanks again! The reason I wanted to see CreateDate and ExpiryDate side by side is that want to get more information about if new users become Subscribers or if they were already for a longer time registered on my site. With that knowledge I can determine what kind of marketing I should run.

Next step is to make a query that lists:

ExpiryDate minus CreateDate < 30
ExpiryDate minus CreateDate < 60
ExpiryDate minus CreateDate < 90..etcetra.

Is it possible to create graphs with the Reports Module? Pictures say more then a thousand words...