Easily query and report data from your external databases in Excel. In real time!
XLReport is an Excel add-on which allows to connect to almost any Data source.
You can then build interactive Queries and insert its Data into Excel as Live, Real-time connected Data sheet or Pivot table which can be automatically deployed to End-users.
There is practically no limitation to building your queries with the XLReport Visual Query Builder. You can even create heterogeneous and union queries from multiple and different data-sources.
Connect to your data
Connect to the most common databases like MS SQL Server, MS Access, MySQL, Oracle, Informix, DB2, Excel, text files and any other database that has an ODBC or OLEDB driver.
Re-use Data Connections
Once you connected to a data source, you can use this link for each new XLReport Query you want to create; no need to re-connect over and over.
Build your XLReport Queries just as you need them
The Visual Query Builder allows you to create any imaginable Query without limitations in a visual drag & drop mode.
There is practically no limitation to building your queries with the XLReport Visual Query Builder.
You can even create heterogeneous and union queries from multiple and different data-sources.
The Visual Query Builder requires only basic SQL knowledge.
The Visual Query Builder allows you to write any imaginable query without limitations in a visual drag & drop mode; no need to write SQL queries manually.
Query without limitations
Filter, apply functions, date functions, concatenate fields, add aggregate & summary functions and create pre-calculated fields.
Assign auto-filters like “Next Month”, “Current Year”, “Next Week”, etc.
Define parameterized queries so when you run it, it prompts for criteria to use. You select the records for the result set so that the same query can be used to retrieve different result sets.
Create Queries from existing XLReport Queries
Besides building queries from your database tables and views, XLReport also allows designing queries from already existing XLReport Queries. It also combines XLReport Queries with database tables and views.
Create variations of your Queries
Edit an existing XLReport Query and save it as a new one, allowing you to create a set of similar queries.
Re-use SQL from other applications
You can copy and paste existing SQL statements from other applications into XLReport and it will construct the Query automatically.
Save your XLReport Queries
Once a Query was saved it is always accessible from within the XLReport Project Explorer.
No need to rebuild it over and over again.
Organize your Queries
Organize your XLReport Queries with projects and folders so you can keep related data (ERP, CRM, Financial, Human Resources, etc.) objects together.
Edit your Queries
You can edit the saved query at any time and also create a variation of it.
Insert the Live Data into Excel
Insert the Query’s underlying data into Excel with a single click as a Static or Real Time Data sheet.
Select the XLReport Query object from within the Project Explorer and insert its underlying data as:
Static Sheet
This inserts the raw static data into Excel.
Live – Real Time Sheet
This inserts a live real time connected data set into Excel.
Live – Real Time Pivot Table
This inserts a live real time connected data set into Excel.
Optionally, you can choose to also insert a live real time connected Pivot Chart.
All prior options allow you to either insert the data into a new Excel sheet or into a specified range.
Enjoy the Power of Excel Reporting
Work with Excel advanced reporting features as usual; format, sort, groups, etc.
There is no limitation what you can do with Excel.
Retrieve your most recent Data
Just click the “Refresh Data” button and your Excel sheet will be updated with Real-time Data from your databases.
If you created a live real time connected XLReport Excel sheet or Pivot Table you only need to click the button “Refresh Data” and XLReport will retrieve all current data.
If you applied formatting to your data prior, it will still be preserved. No need to re-format your reports repeatedly.
If parameters were defined in the query, clicking the “Refresh Parameter” button will ask you to enter new input parameters.
Clicking the “Refresh Fields” button it will refresh with the most recent field definition of the underlying query.
Be secure
Your Data Connection strings are encrypted and not visible to end-users.
This makes it secure to deploy XLReport Excel files to end-users.
Create user groups and users and assign object privileges when saving a new Query.
Automatically deploy XLReport Query objects to your co-workers
The XLReport Report Server allows instant Query Object deployments to End-users.
End-users can run any Real-Time query which was assigned to the User Group they belong to.
XLReport uses a Report Server (optionally Web Service) to which Admin and Viewer users are connected. When saving a Query Object, it will be immediately available to the End-users.
XLReport version: 2.1.0
File Size: 151 MB | Release Date: July 11, 2020
Technical Requirements
- Windows XP, Server 2008+, Vista, 7, 8, 10
- MS Excel 2007, 2010, 2013, 2016 (32 bits – 64 bits)
- 160 MB available space on hard disk drive