Last post May 24, 2005 03:40 PM by mcsenow
May 24, 2005 03:40 PM|mcsenow|LINK
If you have a need to run report against different db vendors and want the reports to show within DNN, try MS SQL reporting services.
Information about MS SQL Reporting Services can be found at
http://www.microsoft.com/sql/reporting/default.asp. It is a free add-on to those who already have license for MS SQL server. To design the report, you can use Visual Studio 2003 and the data
source can be MS SQL, Oracle, DB2, MySQL, Access, etc.
There is a demo of the reports integrated within DNN at
http://corpdnn.icpconline.com/dotnetnuke/ReportServices/tabid/54/Default.aspx. You can also download the free dnn module there. The online demo includes
1 - Simple Reports from Northwind DB
2 - Catalog/Sales Reports
3 - Financial Reports
4 - Great Plains Reports
5 - CRM Reports
6 - Exchange Email Server Statistic Reports
7 - IIS Log Reports (potential to enhance DNN log)
The module source code is availabe to those who would like to extend the module functionalites or need to debug the code