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.

XLReport is an Excel add-on
Play Video about XLReport is an Excel add-on

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.

Show more...

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.

Show more...

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.

Show more...

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.

Show more...

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.

Show more...

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.

Show more...

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.

 
Show more...

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.

 
Show more...

XLReport version: 2.1.0

File Size: 151 MB | Release Date: July 11, 2020

Technical Requirements​

All Rights Reserved by XLReport – 2022.

Privacy

We use cookies

We use cookies and other tracking technologies to improve your browsing experience on our website, to show you personalized content and to analyze our website traffic, and to understand where our visitors are coming from. By browsing our website, you consent to our use of cookies and other tracking technologies.

Contact us