Painless Real Time
Data Analysis,
Reports
& Dashboards
with Excel
Easy Live Data Connections
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.
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
There is no limitation to building your queries.
- The Visual Query Builder requires only basic SQL knowledge
- Query without limitations
- Create Queries from existing XLReport Queries
- Create variations of your Queries
- Re-use SQL from other applications
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 XLReport Queries with projects and folders so you can keep related data (ERP, CRM, Financial, Human Resources, etc.) objects together.
You can edit the saved query at any time and also create a variation of it.
Insert the queried Data into Excel
Select the XLReport Query object from within the Project Explorer and insert its underlying data as:
Static Sheet. Insert the raw static data.
Real Time Sheet. Insert a live real time connected data set.
Real Time Pivot Table. Insert a live real time connected pivot table.
Retrieve your most recent Data
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.
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.
Easily distribute your XLReport Queries
If you distribute an Excel file with an embedded real time connected XLReport, then the end user only needs to "Refresh" the sheet and they will receive the most current data set.
If several people are working on creating XLReport Excel files, you can export and import individual XLReport objects and projects to deploy to other users.
Easy Live Data Connections