I have had this problem for a while and have searched the internet many times but I am unable to find a fix to the problem.In the Event Viewer, I get the following General Exception from the Reports Module:

AssemblyVersion: 6.1.2
PortalID: -1
PortalName:
UserID: -1
UserName:
ActiveTabID: -1
ActiveTabName:
RawURL:
AbsoluteURL:
AbsoluteURLReferrer:
UserAgent:
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: eacf7ccd-d9a1-49a5-8ea7-ca24e1a9e794
InnerException: Object reference not set to an instance of an object.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: DotNetNuke.Modules.Reports.ReportsController.BuildParameters
StackTrace:
Message: System.NullReferenceException: Object reference not set to an instance of an object. at DotNetNuke.Modules.Reports.ReportsController.BuildParameters(PortalModuleBase SrcModule, ReportInfo Report) at DotNetNuke.Modules.Reports.ReportsController.ExecuteReport(ReportInfo objReport, String cacheKey, Boolean bypassCache, PortalModuleBase hostModule, Boolean& fromCache) at DotNetNuke.Modules.Reports.ReportsController.ExecuteReport(ReportInfo objReport, String cacheKey, Boolean bypassCache, PortalModuleBase hostModule) at DotNetNuke.Modules.Reports.ReportsController.GetSearchItems(ModuleInfo ModInfo) at DotNetNuke.Services.Search.ModuleIndexer.GetSearchIndexItems(Int32 PortalID)
Source:

I know that this issue was previously listed as a bug that was resolved (I think back in 2007). However, I am still having the issue.

I am running DNN 6.1.2 and Reports Module 5.5. Again I have has this issue on other systems that I have used the Reports Module. Does anyone know a workaround or resolution? Or know what I am doing wrong?

Here are my settings:

Title: My Report
Description: This is the report to be viewed.
Allowed Uri Parameters: view
Active Data Source: DotNetNuke Data Source
Upload SQL File:
Querry: EXEC COG_GetPhoneListForDepartment @url_view
HTML Decode:
HTML Encode:
Caching: Not Checked
Show Info Pane: Not Checked
Show Controls: Not Checked
Auto Run Report: Checked
Active Visualizer: XSL Transformation Visualizer
File (A File On Your Site): Checked
File Location" PhoneList/
File Name: PhoneList.xsl
Xml Namespace:
.Net Type:

Joe,
Thanks for your response. I did as you said. I changed to the Grid Visualizer and, as usual, the expected data results were returned. I then re-indexed the site (Host -> Search Admin -> Re-Index Content), and I get the exact same error as listed above.
I then changed back to the XSL Visualizer and then entered a very simple query ("SELECT FirstName FROM  Users"), re-indexed the site, and I get the exact same error as listed above.

Just as an FYI, what I am attempting to accomplish is what is done here (awesome article). Again, I get the expected response and output, but I continue to get the error in the error log.