Let me start with the basic info... I am running DNN 6.2.1 with Reports 5.5.0.
I am using the Reports module to do some reporting out of a Microsoft Access 2003 database. This has been working great and I am very pleased with the result.
I am having a problem with a new report and I'm not sure if it is the data provider, Access itself, the visualizer or what.
I have a query that runs fine in Access. It contains two "calculated columns" that call functions I have in an Access Module to calculate the values. These two columns come up blank (no data) when the Report is displayed. All of the standard columns display fine.
Here are the specifics on the Reports module setup...
Visualizer: "XSL Transformation Visualizer"
Data source: "Generic ADO.Net Data SOurce"
ADO.Net Data Provider: "OleDb Data Provider
Connection String is "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:\Shared\Database\Hours.mdb"
Query" "SELECT * FROM BudgetCases ORDER BY [Office],[Employee ID1] ASC, [Case Number] ASC"
"BudgetCases" is the query I created in Access that contains the 2 "calculated columns" along with a number or regular columns. I decided to use a query because of the calculated columns as well as the fact that it joins a number of different tables. As stated previously it runs fine in Access (displays the two "calculated columns".
I suspect it the Jet Data Provider but I'm not certain. Any suggestions would be greatly appreciated.