Integrated reporting tool for DotNetNuke and MS SQL Reporting Services

To succeed in today's competitive marketplace, organizations must extend information beyond their organization and seamlessly interact with customers, partners, and suppliers in real time. Microsoft SQL Server Reporting Services (SSRS) enables you to transform valuable enterprise data into shared information to help make insightful, timely decisions at a lower total cost of ownership. ReportXP is able to bring MS SQL Reporting Services 2000/2005 to DotNetNuke.

Basic Features

• Embeds reports inside DotNetNuke portal
• Exports the browser-based reports to Excel, PDF, Web archive MHTML, TIFF, XML, CSV
• Supports printing and print preview
• Enables interactivity in the reports (collapsible sections, interactive sorting)
• Provides flexible settings
  • Specify report server per instance of ReportXP in the portal
  • Pick and choose report folder and default report to display

Advanced Features

• Integrates security between Reporting Services Server and DotNetNuke
• Uses DotNetNuke Security Roles to control access to the page containing the reports
• Replaces Windows authentication with DotNetNuke Forms Authentication.  No more Windows login prompts
• Authorizes permission to report folders and items inside Reporting Services/Report Manager using DotNetNuke user accounts
• Publishes reports to the server using DotNetNuke account instead of Windows accounts.

Benefits

Comprehensive server-based solution

• Author, manage, and deliver bother paper-oriented and interactive web-based reports
• Easy to integrate the viewing of reports into your DotNetNuke portal
• The module setting is straightforward, quick, and efficient.

Supports multiple export formats and printing

Format	Description	Recommendations
Excel	Opens a report in Microsoft Excel.	Use this format to manipulate report data in Microsoft Excel 2000 or later.
Web archive	Opens a report in MHTML. The report opens in Internet Explorer. This is the default rendering format for Internet Explorer 6.0.	In contrast with other HTML rendering extensions, the Web archive format produces a self-contained, portable report (embeds images within the report). Use this format to view HTML reports offline or for e-mail-based delivery.
Acrobat (PDF) file	Opens a report in Adobe Acrobat Reader (version 6.0 or later).	Use this format to print paginated reports or to create PDF versions of a report.
TIFF	Opens a report in a page-oriented format. The version of the Windows operating system determines which application is used.	Use this format to print paginated reports. This format is useful if you don't have Acrobat Reader installed.
XML	Opens a report in XML. The report opens in a browser.	Use this format to copy report data from a report server to other applications or servers.
CSV	Opens a report in comma-delimited format. The report opens in an application associated with CSV file formats.	This format produces the smallest file size. Use this format to copy report data from a report server to other applications or servers.

Low cost of ownership

• No limit on user licenses
• System pays for itself in short period of time

System Requirements

• DotNetNuke version 4.7 or higher
• Microsoft SQL version 2000 or higher

Screenshots

	Embeded report in DotNetNuke portal
	Exportable Data Options
	ReportXP Module Settings
	Integrated Security Extension with DotNetNuke user accounts to authorize permission to access the reports

Supports

We make our products easy to use with step-by-step installation and user guides.  For questions or suggestions, you can post them in the forum.  The online demo provides a convenient way to test drive the module.

• Extensive Documentation
  • Step-by-step instructions to install and configure - ReportXP_InstallationGuide.pdf
  • User guide to add and manage users- ReportXP_UserGuide.pdf
• Support Forum
  • Report bugs or request new enhancements
  • Monitored and answered promptly by developers of the module
• Complete Online Demo
  • The online demo showcases a variety of reports that can be brought into the DotNetNuke portal
    1. Simple Reports - reports from Northwind database
    2. Sales Reports - six sample reports from Adventure sales database
    3. Financial Reports - six samples of financial reports that let you easily visualize key finance activities
    4. Great Plains Reports - eleven sample reports from Great Plains database
    5. CRM Reports - six reports that work with the Microsoft CRM 1.2 sample database
    6. Email Server Reports - eleven reports that show Microsoft Exchange server status
    7. IIS Reports - eleven sample reports shows Microsoft Exchange server status
• Video Tutorial
  • ReportXP version 2007 Installation Tutorial
• Customization
  • Source code is available for purchase
  • Available consulting services from InDyne