Icon of program: Report Genie

Report Genie for Windows

Download now

Used Report Genie for Windows?

Editors’ Review

Download.com staff
Report Genie is a free tool for generating Excel reports from SQL queries. It connects to diverse data sources, handles multiple queries per report, and offers scheduling and email distribution.

  • Pros

    • Connects to diverse data sources via ODBC or OLE DB.
    • Supports multiple queries with distinct connections per report.
    • Generates reports in Excel, Text, HTML, and XML formats.
    • Enables report scheduling via command-line arguments.
    • Automatically emails reports using SMTP or Exchange protocols.

  • Cons

    • Requires user knowledge of SQL for query creation.
    • Scheduling relies on external Windows Scheduled Tasks.
    • Lacks specific features for advanced report layout design.
    • No explicit mention of user roles or access permissions.
    • Implied to be limited to the Windows operating system.
Icon of program: Report Genie

Report Genie for Windows

Download now

Used Report Genie for Windows?

Explore More

Full Specifications

GENERAL
Release
Latest update
Version
1.2
OPERATING SYSTEMS
Platform
Windows
Operating System
  • Windows Vista
  • Windows XP
  • Windows 7
  • Windows 10
  • Windows 2000
Additional Requirements
Microsoft Office 2003, .NET Framework 2.0
POPULARITY
Total Downloads
1,376
Downloads Last Week
0
Report Software

Program available in other languages

Last Updated

User Reviews

4/5

1 User Votes

Developer’s Description

By UpTier
Easy database reporting to Excel, w/ scheduling and email capabilities
Report Genie, v1.2,is a free user-friendly reporting tool to help businesses generate Excel reports based on SQL queries using VB.net and Excel libraries.

Main Features include:

1. Using ODBC or OLE DB to connect any data source.Specify your connection string, you can connect to database, such as MS Access, Oracle, SQL Server, even Excel or text files. 2. Each report can contain multiple queries. Tired of having one query per excel report? Report Genie allows you to configure multiple queries for one report, each query could have its own database connections. The resulting excel reports will have one worksheet per query.3. Support multiple output formats.Report Genie supports multiple result formats, such as Excel, Text and HTML. Version 1.2 also support XML spreadsheet format that can be opened by Excel.4. Report could be run using command arguments.This provides users the capability to schedule a report to run at specific time and frequency using Windows Scheduled Tasks.5. Reports can be emailed out to recipients specified automatically. Whether using SMTP or Exchange, you can configure the genie to have the reports emailed out automatically. For text or HTML reports, you have the option to email the report as an attachment or as part of the message body.
Download.com
Your review for Report Genie